how do I find all the rows containing a specific value in excel

M

MadProphet

I have a spreadsheet that looks something like this

Edit # Edit Descr. A B C...
0001 Missing Name 1 1 3
0002 Missing Phone 3 1 1
0003 Missing Zip 1 1 2

I want to find all the rows that contain the value 3 in the A, B, or C
columns.

I am stuck.

Please help!
 
M

Mike H

You have an answer in your other post

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

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

filtering rows across several columns 1
Transfer array element offset value to a matched value 3
Supressing a #VALUE! error returned? 3
How can I create a list of links (A to B) & search for both A & B 3
Lookup and return 2
query to change the layout of a table 1
Looping and Comparing values in two workbooks 1
Input specific value into cell if Row has data 3

Top