Identify Highest Numeric Value of Duplicate Names

Administrative Note:

Welcome to the forum.

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

For recent versions of Excel;:

=B2=MAXIFS($B$2:$B$8,$A$2:$A$8,A2)

For older versions:

=B2=MAX(IF($A$2:$A$8=A2,$B$2:$B$8))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Can you please attach a workbook showing what you have tried? It will be easier to diagnose.

2016 does not have MAXIFS.

If you want to return the max number instead of true or false, use this:

=MAX(IF($A$2:$A$8=A2,$B$2:$B$8))

If this isn't what you want, then show in the workbook (manually) the results you want.

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D
1	name	score	TRUE/FALSE	MAX AMOUNT
2	Spot	5	FALSE	7
3	Dino	4	FALSE	9
4	Dino	9	TRUE	9
5	Fido	6	TRUE	6
6	Spot	2	FALSE	7
7	Spot	7	TRUE	7
8	Fido	2	FALSE	6

Sheet: Sheet1

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	C	D
2	=B2=MAX(IF($A$2:$A$8=A2,$B$2:$B$8))	=MAX(IF($A$2:$A$8=A2,$B$2:$B$8))

Sheet: Sheet1

It will be the way you were trying to enter the formula.

Glad to have helped.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.