Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rank excluding Errors
Hello,
I've searched for a solution here, but I'm not able to find any. My formulas: =RANK(C12;IF(ISNUMBER(C$7:C$55);C$7:C$55;"");0) or =RANK(C13;IF(ISERROR(C$7:C$55);"";C$7:C$55);0) entered as an array formula. The range C7:C55 contains error values like #N/A. I tried to exclude them like the way I' ve done it before with AVERAGE or MAX function, but it doesn't work. I would appreciate to get a solution for this problem. Thanks. Regards Werner |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trend excluding errors or "" | Excel Worksheet Functions | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |