Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
CONTAINSSTRING is a function, verifying, whether there is some textstring. CONTAINSSTRINGEXACT works similarly but is case sensitive.
It is simple. If there is “small pink pig” in column Item, then this:
returns True. On the other hand this:
returns False.
These functions are quite missing in Excel (outside DAX), where have to be replaced by complicated combination like:
Comments are closed.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.
Hi, can you use this to find text from one column in another column in the same table, IE reference the row and column instead of using a boolean?
“These functions are quite missing in Excel ” – have you tried the “FIND” function? Maybe learn a little excel before you decide what is missing. Granted find is case insensitive, but honestly I prefer it that way!
Yes, you can use FIND – but then you need something like IFERROR, ISNUMBER etc. to get TRUE or FALSE result.