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?
Bookmarks