Get Most Frequent Text with Reference to a Cell Value

[krllb]

Hi Guru's

Good Day! Need your help how to determine a cell value (BIN Coordinate) based on the most frequent time the text appears. Thanks!
[TABLE="width: 342"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Enter Plant:[/TD]
[TD]D301[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BIN Coordinate[/TD]
[TD]_???_____[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Expected Value:[/TD]
[TD]Y03-A01-01[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PLANT[/TD]
[TD]BIN Coordinate[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]100D[/TD]
[TD]B01-A01-01[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]100D[/TD]
[TD]B01-A02-01[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]100D[/TD]
[TD]B01-A03-01[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]V94-B01-01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]V94-B03-01[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]V94-B04-01[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]V94-C04-01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]Y03-A01-01[/TD]
[TD="align: right"]24[/TD]
[/TR]
[TR]
[TD]D301[/TD]
[TD]Y04-A01-01[/TD]
[TD="align: right"]16[/TD]
[/TR]
</tbody>[/TABLE]

 

[Saba Sabaratnam]

Hi Krllb,

Enter your data from A4 to C13 Range

Enter Plant in Cell B1

Enter the following array formula in B2 by pressing Shift + Control + Enter

=INDEX($B$4:$B$13,MATCH(MAX(IF($B$1=$A$4:$A$13,$C$4:$C$13,"")),IF($B$1=$A$4:$A$13,$C$4:$C$13,""),0))

Kind regards

Saba

 

[krllb]

Thanks a lot Saba!

 

[jtakw]

Double posted here: https://www.mrexcel.com/forum/excel-questions/1065485-return-maximum-text-value.html

 

[Fluff]

@krllb
In future please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).