=MINIFS(Sheet2!F:F,Sheet2!M:M,A2)
Sheet2!F:F : Dates - because I want the minimum date from a list of dates
Sheet2!M:M : Searches this column for my key
A2: search this is the key for which I want to find out the minimum date in column M
Column F Column M
22/11/2011 NA
27/11/2011 NA
13/12/2021 Cluster_18
18/09/2013 Cluster_18
Final result:
Cluster_18 18/09/2013
The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.
No comments:
Post a Comment