Advanced Filter: what are the

  • Thread starter Thread starter blimp
  • Start date Start date
B

blimp

HI,
I am trying to do a filter on 10 samples from a range
A24:P24, including the header.

I have got my 10 samples from A12:A22, including the
header. Criteria is based on data in column A only.

I set COpied To to A1 (A1 to A22 are all blank rows)
So
List Range:

After clicking on
 
HI,
I am trying to do a filter on 10 samples from a data range
A24:P249, including the header.

I have got my 10 samples from A12:A22, including the
header. Criteria is based on data in column A only.
Rows 1 to 11 are blank rows.

So
List Range: A24: P249 (with header)
Criteria Range: A12:A22 (with header)
Copy to: A1

After clicking on OK, all I got were blank rows, & a
header row posted in row 1.

There must be something wrong in the parameters?
Hope someone could help?
 
Hi,

I believe that's because your "Copy to" location precedes your list to
be filtered.

So you may want to try changing the location to either somewhere after
the list or another worksheet.

Hope this helps!
 
An Advanced Filter extract will delete everything in the rows below it.
Instead of starting the extract in cell A1, use a cell to the right of
the existing table, for example cell S1.

Or, if there will only be ten records pulled, you could use VLOOKUP
formulas to return the data.
 
thanks Debra... got it now.
I need data from 15 other columns related to the 10
records... so i suppose the vlookup formula may not be the
best idea?
thanks anyway.
 
hi, thanks.

I tried changing the location of the copied cells, so it's
working all right now.
IT doens't allow me to copy to another worksheet though.
 
Back
Top