Snasui Excel Forum

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,

...

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

Thank you,it works