Return Maximum Text Value

[krllb]

Dear Guru's

Good day! Need your help on how to get the cell value (Bin Coordinate) using maximum count with reference to cell Enter Plant (ex. D301). Many thanks in advance.

	A	B	C
1	Enter Plant:	D301
2	BIN Coordinate	????????
3	Expected Value:	Y03-A01-01
4
5	PLANT	BIN Coordinate	Count
6	100D	B01-A01-01	4
7	100D	B01-A02-01	5
8	100D	B01-A03-01	3
9	D301	V94-B01-01	1
10	D301	V94-B03-01	3
11	D301	V94-B04-01	11
12	D301	V94-C04-01	1
13	D301	Y03-A01-01	24
14	D301	Y04-A01-01	16

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

 

[Marcelo Branco]

Try this array formula in B2
=INDEX(B6:B14,MATCH(MAX(IF(A6:A14=B1,C6:C14)),IF(A6:A14=B1,C6:C14),0))
Ctrl+Shift+Enter, not just Enter

M.

 

[jtakw]

Nvm, solution provided.

 

[krllb]

Wow! you guys are fast...will try this. Thanks!

 

[jtakw]

Double post, original post here: https://www.mrexcel.com/forum/excel...nt-text-reference-cell-value.html#post5116943

 

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