Hi All
I need some help with a formula that would return a contract name to a summary sheet however it is complicated due to the way the data is laid out.
I am hoping either a formula can do this but a pivot table would be ok if this can be done on multiple ranges.
On the summary sheet I have two columns for each BU (Contract and Overhead). If in columns F,O or X it contains a “C” then it would need to go to column D of the summary sheet or if it contains a “O” then it would need to be returned to column E.
The problem I have is that I have empty rows in the data which need to be ignored.
On the attached example I have populated what I need – I have done this manually.
Can anyone help at all?
Bookmarks