Sir, i am attaching a work book containing datas in differenct work sheets and the abstract report in one work sheet, i want to know the certain formulas will apply to get automatically how many works are completed, progress, not started http://www.4shared.com/document/XRXE...ss_Report.html
pls find necessary function for extracting "Augmenation of PWSS to Narasapuram of Peddapappur Mandal" to one cell "Augmenation of PWSS to Narasapuram" and "Peddapappur Mandal" to another cell