VBA code or a formula for the following please:
I have the words "Li" "Ma" "Ar" "Sp" "Ms" Ch" in the columns C, D, E, F, G and H respectively. They are in row 61 of the excel sheet. I then have numbers underneath each for about 20 rows. I need a formula or VBA code that looks at each row starting at row 62 and ranks "Li" "Ma" "Ar" "Sp" "Ms" Ch" from highest value to lowest depending on the figure beneath it and rank them in columns K,L,M,N and O in the same row as the values.
Thanks for your help
I have the words "Li" "Ma" "Ar" "Sp" "Ms" Ch" in the columns C, D, E, F, G and H respectively. They are in row 61 of the excel sheet. I then have numbers underneath each for about 20 rows. I need a formula or VBA code that looks at each row starting at row 62 and ranks "Li" "Ma" "Ar" "Sp" "Ms" Ch" from highest value to lowest depending on the figure beneath it and rank them in columns K,L,M,N and O in the same row as the values.
Thanks for your help