Hello,

I have a spreadsheet with several thousand rows of data.

In column A I have a list of customer id numbers and in column B I have a list of order dates. I have duplicate customer ids with several different dates. EG I could have a customer id of 200000 with several different order dates in 2017.

In column E & F I want to return a unique customer id from the list in column A with the most recent order date in column F. extracted from column B.

Is there a formula or formulas to return the result I require.

Many thanks for your assistance.