In Excel 2007, how can I compare 15 values on the same row (row 9) with each other and then enter a 1 for the cell with lowest value, 2 for the cell with second lowest value and so on?
The first value to be compared is in cell ak9, the next in cell aq9, next in aw9 and so on (total number of values to be compared are 15).
The result for each compared cell should then be written out in the adjacent cell to the right of the compared cell.
AK9: Value 14.0 (always about this type of number, one decimal, around 07.00 to 37.00 maximum, no need to specify just to give an idea of type of figures in the cells).
In above example, "1" should be written out in cell AX9, "2" in cell AL9, and "3" in cell AR9.
Finally, I would like this same VBA subroutine to be run also for rows 12, 15, 26, 31, 36, 41, 46, and 62 (but if more rows are inserted later, the subroutine should automatically be adjusted to reflect this insertion of new rows in the worksheet).
N.B.! For all rows except row 9 and 15, instead of lowest value here it should be highest value assigned a "1", second highest value assigned a "2", and so on.