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

's Computer Specifications

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!

's Computer Specifications

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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel VBA to select specific rows	dodong	Microsoft Excel Discussion	3	12th May 2010 01:01 PM
How do I find and copy rows based on specific criteria?	Georgew	Microsoft Excel New Users	3	29th May 2009 11:07 AM
Need the VBA to hide rows in excel where a specific criteria is me	=?Utf-8?B?S0JW?=	Microsoft Access	1	4th Jul 2006 02:48 AM
How do I repeat rows at the top of specific pages (Excel)?	=?Utf-8?B?dmxkYW5uZXI=?=	Microsoft Excel Misc	0	16th Jan 2006 03:23 PM
How do I get a specific list of rows out of a much larger excel s.	=?Utf-8?B?bGFya2luZGFsZQ==?=	Microsoft Excel Worksheet Functions	2	7th Dec 2004 09:55 PM