Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Rank Troubleshooting
Are there any suggestions for troubleshooting the following (conditional
rank)formula, which is not properly correcting for tied ranks as I think it should (ie, it is assigning the same rank more than once)? {=SUMPRODUCT(($A$5:$A$1000=A100)*IF(ISNUMBER($B$5: $B$1000),$B$5:$B$1000-ROW($B$5:$B$1000)/1E9=B100-ROW(B100)/1E9))} Thanks, IP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Rank Troubleshooting
Hello,
Have a look at my more complex example on http://www.sulprobil.com/html/sorting.html Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Rank | Excel Worksheet Functions | |||
Conditional formatting troubleshooting | 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) |