Which rows contain certain text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Would love to write macro to delete any row that DOESN'T containspecific text.. 6
Eliminate blank row at top of Text Box entries 3
Single Row to Multiple Row Determination 1
Delete rows based on contents of Col A 0
Unwanted Calculation 5
Search for cells that DO NOT contain specific text 4
Macro analyses Cell . If text found , delets entire row 6
Excel 2003 - Macro for deleting rows 7

Back
Top