table 6 rows by 3 columns with random alphanumeric chars, I want to assign numeric values

[Michael Island]

Hi I have a table with 6 rows by 3 columns with random alphanumeric chars, I want to assign numeric values to those chars based on their positions and then get the char with most value.I attach an example worksheet.

[Pete_UK]

Your example file doesn't really explain what you want to achieve.

Please put together a few examples (manually), so that we can take it forward.

Pete

[Michael Island]

OK,

Pretty much if the strings are in the first column they get assigned 20 points.
The strings in column 2 are assigned 15 points
The strings in column 3 are assigned 10 points

The strings that match are the same so we add their values together and get a total - if there is more than one string with a the same max total then they should be shown.

[Michael Island]

This example might help.

[Pete_UK]

I'm still not really sure what you want to achieve, but you can get a total score for each name (excluding duplicates) using this formula in K7:

=IF(COUNTIF($I$7:$I7,I7)=1,SUMIFS($J$7:$J$24,$I$7:$I$24,I7),"")

Copy down to K24. Then you can rank those total scores using this formula in L7:

=IF(K7="","",RANK(K7,$K$7:$K$24)+COUNTIF($K$7:$K7,K7)-1)

Again, copy down.

Then you can get the highest scorer with this formula:

=INDEX($I$7:$I$24,MATCH(1,$L$7:$L$24,0))

Hope this helps.

Pete