Ranking My Products

[carl]

I have a spreadsheet like this:

ColA ColB ColC ColD ColE
Product My Sales ABC's Sales DEF's Sales HIJ's
Toaster 1000 20 300 5000

I am trying to put a formula in ColF that will return my
rank as 1,2,3 or 4. For example, in this case the formula
would return 2.

Is it possible ?

Thank you in advance.

 

[Frank Kabel]

Hi
have a look at the RANK function for this. See:
http://www.cpearson.com/excel/rank.htm

 

[Domenic]

Hi,

Try putting this formula in cell F2 and copy down:

=RANK(B2,B2:E2)

Hope this helps!

 

[Bob Phillips]

=RANK(B2,$B$2:$E$2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)