Hi All
I have been struggling with this for a while, so it's time I ask the professionals
The attached workbook has 2 sheets. Clients and Reports
I am trying to add formulas to the Clients sheet that will show if a client has a certain report element across any of their reports
I used a COUNTIFS formula for the SLA column which worked, but might not be the best solution.
Essentially it's saying:
IF you find the account number on the Reports sheet AND IF the [SLA] column on the reports sheet is not blank, then count it.
Then replace anything great than 0 with an 'x' as the count value itself is not important
I was hoping to adapt this formula for the MI column on the Clients sheet, but this would require checking to see of a range of columns in the Reports sheet are not blank. The [Exec Summary]:[DNA & Canx] columnsPlease Login or Register to view this content.
But unfortunately this doesn't workPlease Login or Register to view this content.
It's likely I am approaching this the wrong way, so any/all advice welcome
Many thanks in advance
Vicky
Bookmarks