Hello All,
I am trying to extract maximum values in a given set of data. I am currently using an array function =MAX(IF($A$2:$A$12=B2,$C$2:$C$12)) ). Every time i need to press Ctrl+Shift+Enter.
Is there anyway that I can get the maximum values out of a given data set without using an array function. I have attached screenshot for ready reference.
Thanks !!
I am trying to extract maximum values in a given set of data. I am currently using an array function =MAX(IF($A$2:$A$12=B2,$C$2:$C$12)) ). Every time i need to press Ctrl+Shift+Enter.
Is there anyway that I can get the maximum values out of a given data set without using an array function. I have attached screenshot for ready reference.
Thanks !!