how to compare cells in excel

June 16, 2011 at 11:07:19
Specs: Windows XP
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.

See More: how to compare cells in excel

Report •

#1
June 16, 2011 at 12:21:05
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.


Report •

#2
June 16, 2011 at 13:25:41
Thanks . RANK function worked perfecrtly. Thanks a bunch.

Report •
Related Solutions


Ask Question