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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,622
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,622
Office Version
365
Platform
Windows
Cheers. Glad to help. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,098,984
Messages
5,465,841
Members
406,449
Latest member
malar11567

This Week's Hot Topics

Top