Cash transactions separation and bank transactions separation

Sno, inv no, paymentl mode, amount

1, 200, cc, 50.00

2, 201, cash, 120.00

3. 202, cash, 24.00

4. 203, cc, 1588.00 

I want formula for to separate the payment mode transactions like cash transactions all together at one place and cc transactions at one place ex: cc, 50.00

                 Cc, 1588.00

 

                 Cash, 120.00

                 Cash, 24.00 

 

For this example I want formula in excel.

By: Bollam Pranay Kumar

Leave a Reply

Your email address will not be published. Required fields are marked *