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.
All help on this matter much appreciated.