View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jamess jamess is offline
external usenet poster
 
Posts: 1
Default Which rows contain certain text?

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