Max for 2 list and then mapping to Letters

Dear All,

I have a 2 list column with 1st with letters and 2nd column with numbers, and need to see what is the maximum according to the right column. The maximum number and numbers below that are mapped to f.e. a letter a has to be mapped to AAA, please see file on link :

http://www.4shared.com/document/jAqsxi4a/teste1.html

hi.. it's good for uploading example but this forum has option for uploading files so you can rather use it then outsources.

But can you also translate your sentence in example to english

Hello, its just means the same as what i asked here in the forum.....well sorry i didnt see this upload feature! LOL

hmmm.. but there is FFF mentioned... And there is no value for f

Thanks for the feedback,

This is just a sample so ...if f is mapped to FFF is not a problem

The ideia is that i can find the maximum value in the values of a or b or c or "whatever", map it to the 3 letters, and all values that are smaller than MAX is also mapped to same 3 letters.

Regards

Originally Posted by zbor

hmmm.. but there is FFF mentioned... And there is no value for f