T
Thyag
Hi All,
I have a column of positive & Negative values.
As given in the Example below ( actual data may run to more than few
thousands of rows ).
Could some one tell me how to find the values which have exact
positive & negative values.
ie., from the example below i need to know : -
1 - 100 & -100 are summing to zero.
2 - second 200 & -200 are summing to zero
3 - first -300 & next 300 are zero when summed
If you need any clarification please post back.
Example
Column A
100
-100
200
200
-200
-300
300
300
300
500
-500
-500
500
500
-500
1000
-1000
-1000
-1000
-1000
1000
Thanks,
Thyagaraj
I have a column of positive & Negative values.
As given in the Example below ( actual data may run to more than few
thousands of rows ).
Could some one tell me how to find the values which have exact
positive & negative values.
ie., from the example below i need to know : -
1 - 100 & -100 are summing to zero.
2 - second 200 & -200 are summing to zero
3 - first -300 & next 300 are zero when summed
If you need any clarification please post back.
Example
Column A
100
-100
200
200
-200
-300
300
300
300
500
-500
-500
500
500
-500
1000
-1000
-1000
-1000
-1000
1000
Thanks,
Thyagaraj