Excel Forum

Posted: **Mon May 29, 2023 12:03 pm**

hi there,

I need your help with office excel 365 formula.

I attach a template

thanks

Posted: **Mon May 29, 2023 1:28 pm**

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

Posted: **Mon May 29, 2023 5:37 pm**

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

Posted: **Tue May 30, 2023 8:10 am**

thank you so much .always awesome

Excel Forum

Transaction reconciliation

Transaction reconciliation

Re: Transaction reconciliation

Re: Transaction reconciliation

Re: Transaction reconciliation