Per attached XLS, I have a cell range (A1:B300) which has 9 paired values as part of the 300 records. Thus, there are 291 rows which currently don't have values.
I would like to create a formula that "screens" through the 300 rows and then (in column D and E) adds the 9 paired values into cell range D1:E9. In the attachment, this process was done manually; however, as additional values may be added/removed from cell range A1:B300, I would like to automate the screening/finding process in cell range D:E.
A picture is worth a thousand words... so, please see the attached XLS for additional details.