I am using the following formula to find the maximum date where all conditions are met. =MAX(IF(B:B=G2,IF(C:C=G3,IF(D:D=G4,A:A,FALSE),FALSE),FALSE))
Where columns B, C and D are filtered to match criteria then from the matching results the maximum date from column A is found.
It works but is extremely slow for large datasets. I'm sure there must be a better way but I can't find a way of returning multiple results from which I can then find the max or min.
Aucun commentaire:
Enregistrer un commentaire