Hello,
I am trying to extract the latest date from a range of dates, with a unique identifier as the criteria. My data looks like:
Sheet1
<tbody>
A
B
</tbody>
<tbody>
Identifier
Dates
12
1/2/1900
10
3/1/1901
12
1/5/1899
13
2/3/1900
19
7/4/1901
10
4/2/1901
12
1/5/1900
14...