formula to derive district with maximum count

vinod9111

Active Member
Joined
Jan 21, 2009
Messages
425
Hi All,

Need a formula to derive the final district by looking at the maximum count. There are duplicate accounts against which there are number of counts, the district with maximum count of these duplicate to be derived in final district column. In event of tie any one of the district can be reported. Final district is the expected results.

AcctDistrictCountFinal district
02211800004661Akola4Akola
02211800004661Washim4Akola
03601800006491Latur7Latur
03601800006491Osmanabad1Latur
18101800000058Nagpur1Wardha
18101800000058Wardha4Wardha
50100001276940Cuddalore1Villupuram
50100001276940Villupuram9Villupuram

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

regards,

Vinod
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,700
Office Version
365
Platform
Windows
This is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}. The formula can then be copied down.

Excel Workbook
ABCD
1AcctDistrictCountFinal district
202211800004661Akola4
Akola
302211800004661Washim4Akola
403601800006491Latur7Latur
503601800006491Osmanabad1Latur
618101800000058Nagpur1Wardha
718101800000058Wardha4Wardha
850100001276940Cuddalore1Villupuram
950100001276940Villupuram9Villupuram
Final District
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,700
Office Version
365
Platform
Windows
Cheers. Glad to help. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,464
Messages
5,468,788
Members
406,606
Latest member
cocobeans

This Week's Hot Topics

Top