Forum Discussion
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...
{=MIN(IF($B$1:$B$10 = "John", $A$1:$A$10))}
array formula
Ctrl + Shift + Enter to complete the formula
Added example file.
Hope I could help you with these information.
I know I don't know anything (Socrates)
Thanks NikolinoDE. Allways returns 00-01-1900
- 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 - array formula - got o the formula and press at the same time " Ctrl + Shift + Enter " to complete, then you will see the right date
