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

Hi James,

Look at the CountIf worksheet function.

To count the number of occurrences of the text in A3 which exist in row 1,
try:

=COUNTIF(1:1,A3)

---
Regards,
Norman



"jamess" wrote in message
...
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