Hi All,
I have two coluns colA & ColB. Col A has numeric values in a random order such as:
Col A
4.2
3.1
5.2
Now i want to write a vba macro which assigns a alphabet to each value in column b (going from max to min). I want to acheive as follows:
Col A ColB
4.2 B
3.1 C
5.2 A
All help is much appreciated.
Thanks.
I have two coluns colA & ColB. Col A has numeric values in a random order such as:
Col A
4.2
3.1
5.2
Now i want to write a vba macro which assigns a alphabet to each value in column b (going from max to min). I want to acheive as follows:
Col A ColB
4.2 B
3.1 C
5.2 A
All help is much appreciated.
Thanks.