Hi I want to compare five cells (total at the bottom ) and assign value accordingly.
the highest number get 1, second highest get '2' and so on.
Look up the RANK function in the Excel Help Files. Come on back with examples of your data if you have problems getting the RANK function to work for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Thanks . RANK function worked perfecrtly. Thanks a bunch.
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |