Martin sherk
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 94
- Office Version
- 365
- 2016
Hello Everyone,
so I am using the below formula for my reconciliation between ERP and bank but I don't quite understand it.
Formulas are in G2 and F2
so I am using the below formula for my reconciliation between ERP and bank but I don't quite understand it.
Formulas are in G2 and F2
Copy of GL CLEAEING_1 (3).XLSX | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Account | Assignment | Document Header Text | Document Number | Amount in local currency | Local Currency | ||||
2 | 2612945 | 5422002132022 | 542200213 | (251.55) | 251.55-1 | AED | ||||
3 | 2612945 | 5422002152022 | 542200215 | (284.17) | 284.17-1 | AED | ||||
4 | 2612945 | 5422002172022 | 542200217 | (1,175.00) | 1175-1 | AED | ||||
5 | 2612945 | 5422002212022 | 542200221 | (389.07) | 389.07-1 | x | AED | |||
6 | 2612945 | 5422002222022 | 542200222 | (5,434.85) | 5434.85-1 | AED | ||||
CTS |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2:F6 | F2 | =IF(E2<0,-E2&"-"&COUNTIF(E$2:E2,E2),E2&"-"&COUNTIF(E$2:E2,E2)) |
G2:G6 | G2 | =IF(COUNTIF($F$2:$F$244,F2)=2,"x","") |