Would you use a Pivat Table or some other form of Reporting the below data?

Originally Posted by FDibbins

Here is an example of what I would use for this - assuming that your latest date (and 1 or 2 before that - your choice) is what you want.

Summary C12=INDEX('Unit 1 2016'!A:A,MATCH(LARGE('Unit 1 2016'!$C:$C,1),'Unit 1 2016'!$C:$C,0))
copied across

The BOLDED part is where it picks the latest date. Change that to 2 for the 2nd latest etc. Also, you will need to adjust the formatting to suite

Well I hope I did this correctly. I basically used your example and updated the bold letters. It seems to be working.

=INDEX('Unit 1 2016'!A:A,MATCH(LARGE('Unit 1 2016'!$C:$C,1),'Unit 1 2016'!$C:$C,0))