I have 10K rows of data, some with multiple rows per employee, I need to filter by unique values by using the employee ID# in 1st column, but filter using the most recent date in another column. I am using Excel 2010. Is there a formula for this?
ID NAME ACT DATE SALARY 123 JOE SMITH 01/02/2012 20000 123 JOE SMITH 02/01/2013 20000
I would only want to see the 2nd row of data for this employee because the act date is the most recent.
EDIT In other words, I want to be able to filter the results of a previous filter.