How to filter rows with commom Nº's in any column

[Moti]

Hello,
How is it posible to filter the common Nº that may appear in an
coloumn

Examlpe:

Coloumn:A B C D E F
Row1: 2 6 8 10 15 20
Row2: 1 2 5 16 25 30
Row3: 4 8 12 19 45 48
Row4: 2 4 15 20 25 28
Row5: 6 9 19 29 39 49
Row6: 8 19 25 28 41 45

In this example I want to filter all the rows that have the common Nº8
The filtered Result Should be shown as below:

Coloumn:A B C D E F
Row1: 2 6 8 10 15 20
Row3: 4 8 12 19 45 48
Row6: 8 19 25 28 41 45

Thank You
Moti

 

[Trevor Shuttleworth]

Use an Advanced Filter with criteria:

B C D E F G
8
8
8
8
8
8


Regards

Trevor

 

[Debra Dalgleish]

Here's the answer you got when you posted this question yesterday in
microsoft.public.excel.misc --


http://groups.google.com/groups?&[email protected]