Hello,

I have data in an excel sheet as per the below appended table. Now I'll be
updating the actual data every month in a different sheet; hence I require a
constant formula( whitout changing the reference cells), which I can drag to
the next line, which will in turn show the ranking for that particular actual
value achieved.

Month Parameter Actual Rank
Jan Service Quality 97.00% 3
Jan Service Quality 99.00% 4
Jan Service Quality 100.00% 5
Feb Service Quality 98.00% 3
Feb Service Quality 99.00% 4
Feb Service Quality 100.00% 5

I have tried using reference( concatanation of month & parameter), but it
doesn't work as actual varies. Please help.

Thanks,
Sam