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!

Enter Plant:	D301
BIN Coordinate	_???_____
Expected Value:	Y03-A01-01
PLANT	BIN Coordinate	Count
100D	B01-A01-01	4
100D	B01-A02-01	5
100D	B01-A03-01	3
D301	V94-B01-01	1
D301	V94-B03-01	3
D301	V94-B04-01	11
D301	V94-C04-01	1
D301	Y03-A01-01	24
D301	Y04-A01-01	16

<tbody>
</tbody>

 

[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).