I have an excel in which values can be same but positive and negative. And can have a value which might not have its counter part (It can be negative/positive).
So how should I Retrieve this value which does not have its counter part.
Please check the screenshot below.
Check the ones marked with red they have +ve and -ve both. Same with the dark blue one also.
Please check the light blue colour marked one. It doesn’t have its counter part.
Yeah, I had to improvise and I solved the issue with the positive/negative case but I am a little bit confused with the number which does not have counterpart.
Your solution was correct for what I was doing earlier but since I am not able to use it now. That’s another case!
@AryanSingh Can you Check this SplitDatatableAndCheck.zip (16.1 KB), This is Same as the previous one, but the condition to split the Datatable into two is Having Positive values in One Table and Negative Values in Other