Hi Richard
I trying to extract three dates against the same ID to use in a spreadsheet table using an imported data. I did use VLOOKUP but it only returns the first date under Misuse criteria it comes to within that Column which is no good, and also tried AGGREGATE but that returns "SMALL" OR "LARGE".
Misuse
Id Location Name Events 1st Event 2nd Event 3rd Event
2125 Location A 3 28/09/2017 17/01/2018 03/07/2020