sample report to post on Excel Forum.zipexample for Excel Form.jpgI have a worksheet with several thousand rows of data which needs to be summarized. Please see an example of 10 rows below. What I need to do is display the results in a heirarchy. For example, look through all the rows and post the first response to Item. In the example I have attached, the formula should:
- look at all rows with a Project number 01. A
- if any of those rows has the number 1 in column E, show the first row in the listing and ignore all other rows (even if there is a number 1 in column E)
- if none of the rows for project number 01. A has a number 1 in column E, then look at column F and show the first row that has a number 1 in column F
- if none of the rows for project number 01. A has a number 1 in columns E or F, then look at column G and display the first row that has a number 1 in column F.
- if none of the rows for project number 01.A has a number 1 in columns E, F, and G, then show the first row that occurs with a number 1 in column H (the N/A column)
Thanks so much for your help! If you think this can be accomplished easier using VBA would appreciate advice on that.
example for Excel Form.jpg
Bookmarks