Page 1 of 1

matching trx

Posted: Tue Jun 22, 2021 1:40 pm
by sna
Hi Dear!
How are you doing?hope you're doing well
I got some problem with matching trx minus and plus sign of the same amount.i need to extract match items as the highlight cells.

I attached a sample

Best Wishes,

Re: matching trx

Posted: Tue Jun 22, 2021 4:09 pm
by norkaz
...

C2 (Helper)

=IFERROR(INDEX($A$1:$A$99,AGGREGATE(15,6,ROW(B3:$B$99)/(B2=-B3:$B$99),COUNTIF($B$2:B2,B2))),"")
Copy down

D2:Fxx

=IFERROR(INDEX($A$2:$C$99,AGGREGATE(15,6,ROW($C$2:$C$99)/($C$2:$C$99<>""),ROW(D1))-1,IF(INT(COLUMNS($D2:E2)/2)=COLUMNS($D2:E2)/2,COLUMN(B2)/2,COLUMNS($D2:E2)/2*2)),"")

G2

=IF(F2="","",-F2)
Copy down

Norkaz

Re: matching trx

Posted: Fri Jun 25, 2021 7:48 pm
by sna
Thank you,it works