If the title isn't clear, here's what [little] I've got so far:
=IF(LOWER(A2)<>SUBSTITUTE(LOWER(A2),LOWER(H2),"",2),"Yes","No")
Which, of course, looks for the H2 ("carwash") value in A2, and if it finds it's been duplicated ("carwash go to the carwash", as an example) it'll Yay or Nay me. The issue is, though, is I need it to look for multiple values for this duplication, or better yet, any duplicated values.
Any ideas?
Bookmarks