Help in classific a group of numbers
Dear all, I would like to have you help. For instance, I have a group of numbers (not in sequence) in Column A. In Column B, I would like to classific the biggest number to be "1", second biggest to be "2", and so on. However, I don't want to just "sort" Column A and use "max" to find the biggest. Please help to suggest some more smart way. Someting like below. A____B 10___5 62___1 39___2 18___4 27___3 27___3 8____6 Thanks a lot. Lawrence ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Help in classific a group of numbers
Use function RANK (see help for more info)
"Lawrence" wrote in message ... Dear all, I would like to have you help. For instance, I have a group of numbers (not in sequence) in Column A. In Column B, I would like to classific the biggest number to be "1", second biggest to be "2", and so on. However, I don't want to just "sort" Column A and use "max" to find the biggest. Please help to suggest some more smart way. Someting like below. A____B 10___5 62___1 39___2 18___4 27___3 27___3 8____6 Thanks a lot. Lawrence ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Help in classific a group of numbers
Thanks RADO but RANK gives duplicate numbers the same rank. The presence of duplicate numbers affects the ranks of subsequent numbers. For example, in a list of integers, if the number 10 appears twice and has a rank of 5, then 11 would have a rank of 7 (no number would have a rank of 6). Please advise. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 07:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com