Excel Champs, I am unable to write an excel formula to arrive case 1. Please help me Regards, Ravi Verma