Filtering a sheet

[Philster316]

Hi there

I have a question about excel 2013.

I have a spreadsheet with a list of number in column A and dates in column B. The numbers in column A are not unique and contain duplicates.

Is there a way I can filter the sheet so that for each number in column A it only shows me the most recent date?

EG
Number Date
45 10/01/2017
45 12/04/2016
23 17/08/2016
23 14/08/2016
23 20/08/2016
45 20/02/2015
57 30/06/2016
57 10/08/2016
12 12/08/2016

Can I apply a filter show that it sheet would only show lines 1,5,7 and 9. Ie the lines with the most recent date for each separate number in column A


Thanks

[jeffreybrown]

One way could be to custom sort your data by date, then in column C use the formula...

=COUNTIF($A$2:A2,A2)

All the unique will now have a 1 which you can filter on