Forum Discussion

Copper Contributor

Aug 17, 2022

Earliest date

Hi, I would like to get the earliest date from a set of data where per each person I've got more than a date. I´m struggling to get the unique name and the earliest date as shown above. Any...

excel

jlgomes

Copper Contributor

Aug 17, 2022

Thanks NikolinoDE. Allways returns 00-01-1900

hansleroy

Iron Contributor

Aug 17, 2022

Hi,
Pivot tables seem me to be the easiest way to go. If yo see zeros, there might be empty rows, or rows with only names.
Kind regards
Hans