issue with ranking

[#1]

Hi All,

I want to find one particular which states 2nd in one and how it ranks in the other state. Is there is any way to find the same. Very urgent request!

Please help me put

Thanks and Regards,

Rikab

[#2]

Anyone having solution for this please!!!