subrosumon
Board Regular
- Joined
- Mar 20, 2014
- Messages
- 124
Hi Expert,
Apologies for consuming your valuable time.
I have a large Data base which is showing with Month as well as client.
(Following example Month, Client and amount)
I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be shown (as result bellow)
is it possible to use vlookup or any other formula?
Thanks in advance
<colgroup><col width="64" style="width: 48pt;" span="2"><colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2327;"><tbody>
</tbody>
Apologies for consuming your valuable time.
I have a large Data base which is showing with Month as well as client.
(Following example Month, Client and amount)
I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be shown (as result bellow)
is it possible to use vlookup or any other formula?
Thanks in advance
Database | ||
Jan-18 | ABC | 1,200 |
Jan-18 | CDF | 1,100 |
Jan-18 | CDF | 500 |
Jan-18 | ABC | 400 |
Jan-18 | ABC | 200 |
Feb-18 | ABC | 1,200 |
Feb-18 | CDF | 2,000 |
Feb-18 | CDF | 4,000 |
Feb-18 | ABC | 3,000 |
Result to be | ||
Jan-18 | ABC | 1,200 |
Jan-18 | ABC | 400 |
Jan-18 | ABC | 200 |
1,800 |
<colgroup><col width="64" style="width: 48pt;" span="2"><colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2327;"><tbody>
</tbody>