oldrin
asked on
conditional ranking
I am using sumproduct function for conditional ranking.
But the ranking is not in sequence when there is a repetition of same amounts.
Please find enclosed sample.
Could you please fine tune the formula so that the ranking by the function is matching with the ranking in the example column ?
Thanks in Advance.
sample-for-conditional-ranking.xlsx
But the ranking is not in sequence when there is a repetition of same amounts.
Please find enclosed sample.
Could you please fine tune the formula so that the ranking by the function is matching with the ranking in the example column ?
Thanks in Advance.
sample-for-conditional-ranking.xlsx
ASKER
Thanks Barry,
Your solution is working and results are as per example.
When I increase the range to above 73 and if the cells are blank then an error is resulted.
Could you please help to resolve this ?
Your solution is working and results are as per example.
When I increase the range to above 73 and if the cells are blank then an error is resulted.
Could you please help to resolve this ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUMPRODUCT(((B$2:B$73<B2)
regards, barry