Hi all, I have attached file where manually i mentioned desired result plz help out to do in Excel 2007.