Vikas, if your data start from A2 (excluding the heading, use the
large function in an array formula
=IF(COUNTIF($A$2:A2,A2)=1,LARGE(($A$2:$A$15=A2)*($C$2:$C$15),1),)
Use CTRL+SHIFT+ENTER to confirm an array formula
On Jul 24, 4:55 pm, vickey vikasda...@gmail.com wrote:
How can I get maximum
Taking Ashish's example which showcases the more versatile sumproduct
function,
Use =IF(COUNTIF($A$2:A2,A2)=1,SUMPRODUCT(MAX(($A$2:$A$15=A2)*($C$2:$C
$15))),) to display the maximum salary only once against each family
Sam Mathai Chacko
On Jul 24, 4:55 pm, vickey vikasda...@gmail.com wrote: