Good evening all,
I was wondering if someone would be kind enough to help mewith the following please?
What I am trying to achieve is the following:
I have been a regular viewer of these forums for year but I haveseriously struggled with trying to achieve the above. I would be really gratefulif someone with more excel knowledge and expertise could help?
P.S - Example data and format below:
A B C D E G H I J
<colgroup><col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<col width="64" style="width: 48pt;" span="2">
<col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;">
<col width="131" style="width: 98pt; mso-width-source: userset; mso-width-alt: 4790;">
<col width="18" style="width: 14pt; mso-width-source: userset; mso-width-alt: 658;">
<col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;">
<col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;" span="2">
<col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;">
<tbody>
</tbody>
Many Thanks in advance!!
I was wondering if someone would be kind enough to help mewith the following please?
What I am trying to achieve is the following:
- Retrieve the gross balance for all accounts (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso 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 (excludingduplicates where there is >1 of the same entry / account) in Column A whilstalso using Concept – ‘’000’’ (Column D) as ‘Criteria’ to drive the overallresult 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 returnedin J2.
I have been a regular viewer of these forums for year but I haveseriously struggled with trying to achieve the above. I would be really gratefulif someone with more excel knowledge and expertise could help?
P.S - Example data and format below:
A B C D E G H I J
ACCOUNT | BALANCE | STATUS | CONCEPT | ON SALE / OFF SALE | Product | Gross Balance | Total # of A/Cs | A/Cs Off Sale | |
10293746 | £20.00 | OPEN | 000 | OFF SALE | PRODUCT X | ||||
10394725 | £30.00 | OPEN | 000 | OFF SALE | Grand Total | £0.00 | 0 | 0 | |
10293645 | £33.00 | OPEN | 000 | OFF SALE | |||||
19273645 | £400.00 | OPEN | 000 | OFF SALE | |||||
10293029 | £1,000.00 | OPEN | 000 | OFF SALE | |||||
80974635 | £90.00 | OPEN | 000 | OFF SALE | |||||
10293029 | £43.00 | OPEN | 000 | OFF SALE | |||||
10293645 | £23.00 | OPEN | 000 | OFF SALE | |||||
10293645 | £1,900.00 | OPEN | 000 | OFF SALE | |||||
10293746 | £600.00 | OPEN | 000 | OFF SALE | |||||
10394725 | £320.00 | OPEN | 000 | OFF SALE | |||||
80974635 | £130.00 | OPEN | 000 | OFF SALE | |||||
80974635 | £500.00 | OPEN | 000 | OFF SALE | |||||
10293746 | £202.00 | OPEN | 000 | OFF SALE | |||||
10293746 | £909.00 | OPEN | 000 | OFF SALE | |||||
10394725 | £620.00 | OPEN | 000 | OFF SALE | |||||
10293029 | £340.00 | OPEN | 000 | OFF SALE | |||||
10293029 | £505.00 | OPEN | 000 | OFF SALE | |||||
10293029 | £9,000.00 | OPEN | 000 | OFF SALE |
Many Thanks in advance!!