View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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!