Good evening all,
Attachment 618731
I was wondering if someone would be kind enough to help me with the following please?
What I am trying to achieve is the following:
- Retrieve the gross balance for all accounts (excluding duplicates where there is >1 of the same entry / account) in Column A whilst also using Status – ‘’Open’’ (Column C) & Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in H2.
- Retrieve the total number of accounts (excluding duplicates where there is >1 of the same entry / account) in Column A whilst also using Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in I2.
- Retrieve the total number of accounts ‘’Off Sale’’ in Column E (excluding duplicates where there is >1 of the same entry / account in Column A) whilst also using Status – ‘’Open’’ (Column C) & Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overall result returned in J2.
I have been a regular viewer of these forums for year but I have seriously struggled with trying to achieve the above. I would be really grateful if someone with more excel knowledge and expertise could help?
Many Thanks in advance!!!
Bookmarks