Remember Me?

#1
September 13th 06, 02:51 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 2
How do you rank in order numbers from highest to the lowest?

For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44

#2
September 13th 06, 03:06 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 132
How do you rank in order numbers from highest to the lowest?

Using the "Large" function - "=Large( array, 2 )" will return the second
largest number in the array.

Regards,
Bill

"Anika" wrote:

For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44

#3
September 13th 06, 03:09 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 3,572
How do you rank in order numbers from highest to the lowest?

With data in A2 to A8, enter this in B2, and copy down:

=RANK(A2,\$A\$2:\$A\$8)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anika" wrote in message
news
For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44

#4
September 13th 06, 03:35 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 2
How do you rank in order numbers from highest to the lowest?

Thank you. It works brilliantly!

"RagDyer" wrote:

With data in A2 to A8, enter this in B2, and copy down:

=RANK(A2,\$A\$2:\$A\$8)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Anika" wrote in message
news
For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44

#5
September 13th 06, 03:35 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2,062
How do you rank in order numbers from highest to the lowest?

If you don't want the duplicates ranked the same
=RANK(A2,A\$2:A\$10)+COUNTIF(A\$2:A2,A2)-1

"Anika" wrote:

For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post LCB Excel Worksheet Functions 7 May 2nd 06 08:48 PM mile3024 Excel Worksheet Functions 2 December 9th 05 10:57 PM Steved Excel Worksheet Functions 7 September 10th 05 09:49 PM Paul A via OfficeKB.com Excel Discussion (Misc queries) 5 July 16th 05 03:54 PM HondaMike Excel Worksheet Functions 1 December 29th 04 11:30 PM

All times are GMT +1. The time now is 11:21 AM.