Haven’t been able to convert the next formula
(the original formula is has ArrayFormula and Ifs statements to make it work for every new row, but it’s not important for the found problem)
Here’s the working example:
What I want to do:
- If column A (#) is unique, do H-L
- If column A (#) is repeated, do H-sum(L)
This is part of a bank statement balance where 1 transaction could be for 1 or many expenses. If not enough expenses are entered or extra expenses are entered, then there’s a remaining balance.
Just pasted the same table and I’m working on it. Feel free to point new ways of doing it.
Thanks in advance.