Well your notes refer to column B only...
anyways try:
copied down![]()
=IF(F16="","",IF(SUMPRODUCT(--ISNUMBER(SEARCH(F16,A16:C16))),"exists","not existing"))
Well your notes refer to column B only...
anyways try:
copied down![]()
=IF(F16="","",IF(SUMPRODUCT(--ISNUMBER(SEARCH(F16,A16:C16))),"exists","not existing"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks