retrieving the last date in a list

[Phill032]

Hi Excel geniuses,

I have a report that lists multiple vehicles that are advertised on the internet.
The list comprises of seperate entries for each time a vehicle has had the price changed.
What i need from this list is the date of the last price change.
Sorry for the sketchy example below but for Stock# 103 i need the date 15 Nov 2017 and so on for each entry.


A B C D
1 STK# VAL1 VAL2 LOG DATE
2 103 10000 9990 01 Nov 2017
3 103 9990 9490 06 Nov 2017
4 103 9490 8990 15 Nov 2017
5 125 19990 18990 03 Nov 2017
6 125 18990 18490 10 Nov 2017

 

[mrshl9898]

How's this?

=MAX(INDIRECT(ADDRESS(MATCH(A2,A:A,0),4)&":"&ADDRESS(MATCH(A2,A:A),4)))

 

[Phill032]

Perfect!! thanks