Forum Discussion

Farlif's avatar
Farlif
Copper Contributor
Dec 22, 2022

Group table lines with cell content

Hello, absolut newbie here, I've got a table with 1600+ lines, and 20+ columns. Now I want to sort them according to "cell content contains word 'keyword' in column F", or better, mark those which co...
excel
Excel on Mac
Farlif's avatar
Farlif
Copper Contributor
Dec 23, 2022
Well, probably too easy for you all. 🙂
I tried =IF(SEARCH("auf",F2,1), x, "") in several variations, but I always get an error message that there's a problem with the function. Can you help me?
  • MY's avatar
    MY
    Brass Contributor
    Dec 23, 2022
    Close but you might have luck with this:
    =IF(ISNUMBER(SEARCH("auf",F2)),"X","")