| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Rank
I am trying to use the following function to rank part of an array based on
one condition, but the function returns the rank for the entire array. Any suggestions? RANK(IF((Calls!$A$1:Calls!$A$1000=Calls!A100),Call s!B100),Calls!$B$1:$B$1000)) Thanks, IP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rank the numbers / range of data using 'RANK' and 'ABS' | Excel Worksheet Functions | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional formatting with Rank | Excel Discussion (Misc queries) | |||
| Conditional Format Rank query | Excel Discussion (Misc queries) | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Threaded Mode
