ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 354
- Office Version
- 365
- Platform
- Windows
sirs,
from the given table.. i would like to deduct payment from the loan amount in which the result will be filtered by those with balances only (ignoring zero balance). If possible with no helper column.
from the given table.. i would like to deduct payment from the loan amount in which the result will be filtered by those with balances only (ignoring zero balance). If possible with no helper column.
testing.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | NAME | LOAN AMOUNT | PAYMENT | |||||
2 | Lara | 10000 | 5000 | |||||
3 | Gayle | 10000 | EXPECTED RESULT | |||||
4 | Ponting | 10000 | 2000 | NAME | BALANCE | |||
5 | Welles | 10000 | Lara | 10000 | ||||
6 | Lara | 3000 | Gayle | 10000 | ||||
7 | Murdoch | 10000 | Welles | 10000 | ||||
8 | Ponting | 3000 | Murdoch | 10000 | ||||
9 | Coolidge | 10000 | 1000 | Porter | 10000 | |||
10 | Porter | 10000 | Coolidge | 9000 | ||||
11 | Lara | 10000 | 2000 | Ponting | 5000 | |||
12 | Perot | 10000 | 10000 | |||||
13 | Kipling | 10000 | 10000 | |||||
14 | ||||||||
Sheet18 |