How can I filter out all but the latest entry in Excel?
June 9, 2009 5:30 PM Subscribe
MS Excel Problem: How can I filter out all but the latest entry for each unique ID?
posted by Serial Killer Slumber Party to Computers & Internet (4 answers total)
I have a data set that consists of a lot ID number, an event date and then details surrounding it. The problem is that each lot ID will have a number of events (and thus a number of rows with the same ID number) and I only want the latest event. I've been playing with the 'advanced filter' option but can't think of a set of criteria to do this. The only solution thus far is to order them by ID and then date and do it manually, however this is going to take a lot of time.