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.