Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Nested RANK functions
I have a sales ladder which ranks my people by the % difference between budget and sales to date, but not everyone has made a sale yet and the % difference is zero for 6 people. These 6 people all have a rank of 75. Where this happens, I want to then rank only those 6 people, based on their budget figure. Is this possible? My current formula reads: =IF(F83=0,75,RANK($G83,$G$9:$G$83,0)) where F is the sales value and G is the % difference. Budget figures are in column D. Thanks in anticipation! :) -- tuph ------------------------------------------------------------------------ tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390 View this thread: http://www.excelforum.com/showthread...hreadid=569284 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way around the maximum of seven nested functions? | Excel Worksheet Functions | |||
Combining SUMPRODUCT and RANK functions | Excel Worksheet Functions | |||
Nested IF's with Rank Problem | Excel Worksheet Functions | |||
how do I use multiple nested functions? | Excel Worksheet Functions | |||
ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions |