Is there a formula that will tell me if the text in A1 is found anywhere else
in Row A? Ideally, I want to enter text in A3, search each row for that
text, put YES in column A, then sort my data to move all the YES rows to the
top. I'm hoping for some method beside looping through each cell in each row.

THIA
JamesS