Hi,

Please anyone help me out for getting the data in attached file.

I just need to fill the nos for a certain Loctaion (ex. "central", "Easteren") in a cell (provided in sheet -Column O, P Q).
pls solve out the data with the help of formuale only, pls don't use coding for the same.

Pls anyone help me out. Hope to hear someone soon.



Rgds
Workbook.xls