Calculating Rank

's Computer Specifications

I would like to calculate the rank of a cell in a group of cells.

ie - I have a number in each cell from b1:b10 In b12 I would like to
have the rank of the number in b1. Then in b13 I would like to have the
rank of the number in b2 and so on.

's Computer Specifications

In B12, try:

=RANK(B1,B$1:B$10)

And drag down to B21.

/i.

"Bill Harrison" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I would like to calculate the rank of a cell in a group of cells.
>
> ie - I have a number in each cell from b1:b10 In b12 I would like to
> have the rank of the number in b1. Then in b13 I would like to have the
> rank of the number in b2 and so on.

's Computer Specifications

=RANK(B1,$B$1:$B$10)

copy down

--

Regards,

Peo Sjoblom

"Bill Harrison" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I would like to calculate the rank of a cell in a group of cells.
>
> ie - I have a number in each cell from b1:b10 In b12 I would like to
> have the rank of the number in b1. Then in b13 I would like to have the
> rank of the number in b2 and so on.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
quad rank 533mhz vs dual rank 800mhz	bryan.hepworth@gmail.com	Computer Hardware	1	24th Mar 2009 06:28 PM
RANK, duplicate ranking but no gaps in rank	arron laing	Microsoft Excel Worksheet Functions	4	14th Jun 2006 07:57 AM
Rank items, select one start date, have remaining dates follow based on rank	rob normerica	Microsoft Excel Misc	1	15th Aug 2005 09:36 PM
Calculating a rank of scores	kieranbeunco	Microsoft Excel Misc	2	21st May 2004 01:52 PM
Calculating Rank in Report or Query	Karrie	Microsoft Access Reports	1	16th Oct 2003 12:05 AM