Analysis of data from one worksheet presented on another

[Joe West]

I maintain a worksheet which runs into almost 10,000 separate rows. This worksheet takes information from reports. I generally record 5 to 40 separate rows for each report, when these items are dealt with I enter a date in the date closed column. On another sheet I maintain a summary of tests that have been performed to date. What I would like to do is use excel formula to add a summary for each report number of what items are open and what have been closed.

All help on this matter much appreciated.

 

[MarkVMcCullagh]

Why not run a pivot table on your worksheet and have a field called status with an if statement where if there is a closed date it says Closed otherwise it says Open.