I’m new to ONLYOFFICE, just moving from MS Office.
I’m trying to use the FILTER Function:
In F I’m heaving cells containing:
F3 bananas, pears, apples
F5 oranges, apples
F6 apples, bananas
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.
=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