Kel,

Post an example of your table and the criteria table you are using.

HTH,
Bernie
MS Excel MVP


"Kel" <Kel @discussions.microsoft.com wrote in message
...
Why is the Advanced Filter extracting only the 1st row of the range in my
spreadsheet? No matter what criteria I use it only pulls the first row. I'm
missing something.
Also, can I use the IF function in my criteria?