Dear all
i have a following data,
<colgroup><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I want the unique list of suppliers (column c), where balance is zero,
means. only need unique list of suppliers where sum of credit-sum of debit of this supplier is zero
the result of this data should be
Asif brother
Asif traders
Please help
thank you
i have a following data,
S No | Date | Supplier | Debit / Credit | BILL NO | Description | Folio | Debit | Credit | each bill balance |
1 | 25-Jun-14 | Asif Traders | Credit | 33 | received bill | 11 | 50000 | ||
2 | 25-Jun-14 | Asif Traders | Debit | 33 | payment againts chq no. 1122 | 12 | 40000 | ||
3 | 05-Jul-14 | ABC TRADERS | Credit | 55 | received bill | 22 | 40000 | ||
4 | 05-Jul-14 | ABC TRADERS | Debit | 56 | payment againts chq no. 1124 | 4 | 40000 | ||
5 | 06-Aug-13 | Asif Brother | Credit | 345 | received bill | 56 | 50000 | ||
06-Aug-13 | Asif Brother | Debit | 33 | payment againts chq no. 1128 | 22 | 25000 |
<colgroup><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I want the unique list of suppliers (column c), where balance is zero,
means. only need unique list of suppliers where sum of credit-sum of debit of this supplier is zero
the result of this data should be
Asif brother
Asif traders
Please help
thank you