searching tips

[Asaf Waknin]

Here is my table of information;

A B C D E F
1 abc MANUF 50 X 40$ 5
2 def cOMM 45 3$ 15
3 DJF COMM 22 X 34$ 3
4 WEF RESD 0 0$ 100
5 WRGF RES 234 x 23$ 23

I would like to display all entries that have an 'x' in col
(d) in a new table. This is an example of my result:

A B C D E F
1 abc MANUF 50 X 40$ 5
2 DJF COMM 22 X 34$ 3
3 WRGF RES 234 x 23$ 23

What would be the formula needed to complete this?

 

[Debra Dalgleish]

If you add a row of headings to your table, you can use an Advanced
Filter to extract the data to a new table.

There are some instructions here:

http://www.contextures.com/xladvfilter01.html