Please assist me. Am i getting "Incorrect argument set" error on below command

Stanzozo

=IF([Status-Calc]@row = "Open", RANKEQ([Top-10]@row + COUNTIFS([Top-10]:[Top-10], @cell <= [Top-10]@row, [Ref Number]:[Ref Number], @cell > [Ref Number]@row)))

Paul Newcome

You don't have a range for your RANKQ function.

=IF([Status-Calc]@row = "Open", RANKEQ([Top-10]@row + COUNTIFS([Top-10]:[Top-10], @cell <= [Top-10]@row, [Ref Number]:[Ref Number], @cell > [Ref Number]@row), RANGE_GOES_HERE))

Stanzozo

=IF([Status-Calc]@row = "Open", RANKEQ([Top-10]@row + COUNTIFS([Top-10]:[Top-10], @cell <= [Ref Number]@row, [Ref Number]:[Ref Number], @cell > [Ref Number]@row), [Ref Number]:[Ref Number])) now giving #no match error

Stanzozo

i am trying to rank top ten users. i used this formula

=IF([Status-Calc]@row = "Open", RANKEQ([Aging Days]@row, [Aging Days]:[Aging Days]), 0)

it gives value 4, 4, 7,10 12,13 ...

now my problem is that when i try to display a report with the top ten it is not coming right. Please help. Thank you