Is there any easy way to do this?
I have 200+ spreadsheets, each with 1000's of lines, that I need to modify. This is an example of the numbers in a column.
2
2
6
6
10
10
15
15
15
15
15
24
27
31
35
35
39
39
44
I need to change them to the sequential letter. The twos, since they are first, would change to As, the sixes, since they are second, would change to Bs, etc.
The catch is that the numbers wouldn't always correspond to the same letter. The sixes might come fourth in the next list and would need to change to Ds, the fourth letter.
Thanks for any help.
David
I have 200+ spreadsheets, each with 1000's of lines, that I need to modify. This is an example of the numbers in a column.
2
2
6
6
10
10
15
15
15
15
15
24
27
31
35
35
39
39
44
I need to change them to the sequential letter. The twos, since they are first, would change to As, the sixes, since they are second, would change to Bs, etc.
The catch is that the numbers wouldn't always correspond to the same letter. The sixes might come fourth in the next list and would need to change to Ds, the fourth letter.
Thanks for any help.
David