Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rank
my post from function's division:
Hi, I have sum data of five columns: col1 col2 col3 col4 col5 sum_of_5_columns item 5 6 6 20 30 67 1 6 5 6 25 20 62 3* 3 5 4 28 22 62 2 etc.. *less sum of last three columns I used function LARGE but occured the same result in sum_of_5_columns. i don't want equal position.. I'd like create (in column item) function with show position from max to min sum_of_5_columns. If sums are equal then count sum of last three columns (3,4,5) If sums are still equal then count sum of last two columns (4,5) If sums are still equal then count value of five column (5) Remark: My data can't be sort by excel. Any help in function or VBA function will be appreciated. I use excel 2k. Best Regards Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |