L
Legacy 396030
Guest
I have this formula array that I want to get the max value from column D when all 3 matches are made:
Does anyone know how to alter this to get the max value?
Thank you very much in advance for your help
BRS
Code:
{=IFERROR(INDEX(D$2:D$12,MATCH(1,($G2=$A$2:$A$12)*($H2=$B$2:$B$12)*($I2=$C$2:$C$12),0)),"")}
Does anyone know how to alter this to get the max value?
Thank you very much in advance for your help
BRS
Last edited by a moderator: