Find Data in Cell
This document is in development
SEARCH finds "text value" in cell A1.
IF result of SEARCH is that the data is found, result returns TRUE. Else, FALSE.
=IF(SEARCH("text value",A1,1),TRUE,FALSE)COUNTA(UNIQUE(A1:B100))
This document is in development
SEARCH finds "text value" in cell A1.
IF result of SEARCH is that the data is found, result returns TRUE. Else, FALSE.
=IF(SEARCH("text value",A1,1),TRUE,FALSE)COUNTA(UNIQUE(A1:B100))