FILTERING THROUGH DUPLICATES BASED ON A DIFFERENT CELL

[kennyslaterr]

Hello, Is there a way to filter and only show one row per supplier name based on the date column.
In the picture below i want to get rid of all the duplicates and only show one row with the most recent year in the date column. Problem is, there are thousands of different supplier names in this work sheet, so I am trying to find the easy way to do it.

 

[Fluff]

Duplicate to: LARGE DATA SET QUESTION

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.