Hello Great minds: If balance is the exact same (to the penny) including differing signs, filter out of dataset as balanced if not then not balanced. Balance 393,025.50-393,025.50 137.88229.58-0.03-200,333.982,674.60-2,878.65109,937.98-109,733.94-576.2760,509.66-59,933.3813,404.70-13,270.01210,763.54-210,898.24-125,953.37150,850.20-20,087.14164,425.52-169,235.2080,405.65-856.39-72,681.6321,384.90-28,252.51386,198.95-386,198.95 Appreciate your help in my learning process.

How can I write a formula to offset balance

Hello Great minds:

If balance is the exact same (to the penny) including differing signs, filter out of dataset as balanced if not then not balanced.

Balance

393,025.50

-393,025.50

137.88
229.58
-0.03
-200,333.98
2,674.60
-2,878.65
109,937.98
-109,733.94
-576.27
60,509.66
-59,933.38
13,404.70
-13,270.01
210,763.54
-210,898.24
-125,953.37
150,850.20
-20,087.14
164,425.52
-169,235.20
80,405.65
-856.39
-72,681.63
21,384.90
-28,252.51
386,198.95
-386,198.95

Appreciate your help in my learning process.

Workflow

Accepted answers

binu_acs

@Kinetic_analytics I am thinking some like this. Let me know if that works for you

offsetbalance_070323.yxmd

binu_acs

@Kinetic_analytics If your data is already double then you don't need the multi-field formula

offsetbalance_070323.yxmd

All comments

binu_acs

@Kinetic_analytics how do you calculate the balance manually ? By comparing the 2 rows?

Kinetic_analytics

@binu_acs I used to do manually.

binu_acs

@Kinetic_analytics Can you explain the steps when you calculate manually? are you taking the difference of the consecutive 2 rows?

Kinetic_analytics

@binu_acs

in the current excel filter those data by considering the fact: If any balance exactly positive and negative matches exact to the point level then those balance are considered as matched. If not matched then need to investigate why those numbers are not matching.