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
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.