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

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!

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

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.


"MadProphet" wrote:

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!