Filter for Partial Text in a Cell

Docs
1

Hi there,

I’m new to ONLYOFFICE, just moving from MS Office.

I’m trying to use the FILTER Function:
=FILTER(C2:H30,F2:F30=“apples”)

In F I’m heaving cells containing:

F2 apples
F3 bananas, pears, apples
F4 bananas
F5 oranges, apples
F6 apples, bananas
F7 grapes
F8 apples
…

The functions works fine of course for F2 and F8, but I’d like to filter for ANY accurance of “apples”, so also F3, F5 and F6.

I tried:
=FILTER(C2:H30,F2:F30=“* apples *”) (→ without the space of course, ** tunres the formatting in here to emphasis)

but ONLYOFFICE doesn’t seem to take the *.

How can I solve this?

Thanks and kind regards
Anika

2

@amk1208 ,
=FILTER($F$2:$F$8,ISNUMBER(SEARCH(“apples”,$F$2:$F$8)))
shall work. If you count manually how many cells are with “apples”, select that number of cells and Ctrl+Shift+Enter above formula in the first cell of the selected range.

1 Like
3

Hi there,
thanks for taking the time! Nice workaround, this works, thanks.

4

Anika, you are welcome.
Unfortunately range is not expanded automatically, but we can nothing to do with that.