Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel change a group of positive numbers to negitive numbers | Excel Discussion (Misc queries) | |||
average a continuous group of numbers and negative numbers are 0 | Excel Worksheet Functions | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |