Snasui Excel Forum

hi there,

I need your help with office excel 365 formula.

I attach a template


thanks

I wanna reconcile transaction with same amount but different signs.

I use Microsoft office Excel 365 so I need formula to solve this.

Thanks for always you kind

Please try,

O3

=LET(a,CHOOSECOLS(FILTER(B2:E14,(E2:E14<>0)*(ISNUMBER(MATCH(E2:E14,F2:F14,0)))),1,4),b,INDEX(a,,1),c,INDEX(a,,2),HSTACK(b,MAP(b,c,LAMBDA(d,e,TAKE(FILTER(B2:B14,(B2:B14>d)*(F2:F14=e)),1))),c,-c))

Enter

thank you so much .always awesome