Advanced Filter deleting first rows.

I have a file with a fund 'ID_number' column, and a 'return' column with 100000+ entries. All the ID numbers have multiple entries. I am currently trying to filter these down to a select column of 'relevant' ID numbers.

Since my 'relevant' list is over 300+ long, and this would take too long using the normal drop-down 'filter' boxes, I have used the Advanced Filter function.

This solution has worked, except I have one problem. For some weird reason, Excel filters out all but one of the rows for the first fund ID.

So, I get all the funds i want, with many rows worth of data for each fund ID (what Im looking for, since I'm looking at different monthly returns), but for some reason I only get 1 row for the 1st fund ID.

Anyone know whats going on?

Unfortunately, when I include the header the filtering doesn't work at all...I can't figure out why. I've also tried inserting some 'fake' rows of data in the hope that the filter will simply delete those rows and leave the rest of my data in tact, but again, when I try that approach the filtering just doesn't work...

Advanced Filter seems pretty temperamental to me! :P

Jodapo

I need to filter an array of numbers. usually would do this using normal filter and clicking the boxes on the dropdown, but I need to filter an array of 4000+ numbers from a list of approx 400,000 records...

The Criteria range is just a column of numbers pasted below the table that I need to be filtered...the table has several columns, the leftmost one of is the 'ID' column which I would like filtered.

Hey.

Sorry for the delay - was having problems with the internet connection over the past week.

Just figured out how to filter using the IF and LOOKUP function, which solves the problem with using the advanced filter function!

Thanks anyway


Jodapo