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]
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]