Thread: advanced filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default advanced filter

Boris,
1) Since you want a copy of the list to another place Advanced Filter
is what you seek.
2) Just click anywhere on the list before issuing the
Data|Filter|Advanced filter command.
3) You will need two cells, one over the other, e.g. AA1 and AA2. In
AA1 you should write the label of the column that you want (i.e.
Person3). In AA2 you will write 1.

When you issue the filter, Excel will ordinarily detect the range for
the first textbox. For the second one you will need to select AA1:AA2.
If you check the option to Make a Copy on Another Location, the you can
click anywehre else you want for the 3rd textbox.

HTH
Kostis Vezerides