Check 2 same values are present but they are negative and positive BUT how should i get the value which doesn't have its counterpart?

@ALL

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.

image

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.

Thanks & Regards
Aryan

@Palaniyappan
@ImPratham45
@supermanPunch

Can you guys help me? Do you guys have any idea of how I can get this value which does not have its counter part?

Thank You
Aryan

Hi
hmm…it looks bit tricky
let me try once and get back to you buddy
@AryanSingh

1 Like

@Palaniyappan

Ok thanx.

Those counter parts will be immediate next only?

@ImPratham45

I am sorry, I didn’t understand you question! :sweat_smile:

@AryanSingh Is this the Same File which was in the Other Post that you have Created? :sweat_smile:

@supermanPunch

Yes bro, I solved one issue, only this one is remaining.

Cheers

No the counterparts can be in any row in the column.(Dynamic index in nature!)

@AryanSingh Isn’t DR and PY Document Type Involved while doing this operation?

1 Like

@supermanPunch

Yeah, it was but there were some new info was provided, than I had to change the reference point from that! :expressionless:

@AryanSingh Ohh Then my old workflow is not all proper :sweat_smile:

@supermanPunch

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!

Thanks buddy
Aryan

@Palaniyappan

Can you help me?

Thanks
Aryan

can you share your excel file for my reference?

@AryanSingh Can you Check this :sweat_smile: 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

@ImPratham45

Please check the excel file.

EXPORT3.XLSX (10.3 KB)

@supermanPunch

Ok thnks bro I will check.

Thanks
Aryan

Hi @AryanSingh

Have you tried using format value activity and based on that you can change it

Thanks
Ashwin.S

@AshwinS2

I am not sure, to change what brother?

Thanks
Aryan

Hi @AryanSingh
Counterpart value brother :slight_smile:

Thanks
Ashwin.S