RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello
I am trying to work out a formula to match the date and amount. If e2=e3 and if f2=f3 then display true, else false.
I am trying to work out a formula to match the date and amount. If e2=e3 and if f2=f3 then display true, else false.
query match date and amount.xlsx | |||||
---|---|---|---|---|---|
D | E | F | |||
1 | Date | Amount | |||
2 | FALSE | 01-05-2020 | 10800.00 | ||
3 | FALSE | 01-05-2020 | 67517.00 | ||
4 | TRUE | 29-09-2020 | 87091.00 | ||
5 | TRUE | 29-09-2020 | 87091.00 | ||
6 | FALSE | 24-07-2020 | 6272.00 | ||
7 | TRUE | 31-10-2020 | 428.81 | ||
8 | TRUE | 31-05-2020 | 428.81 | ||
9 | FALSE | 31-01-2021 | 857.62 | ||
10 | FALSE | 30-09-2020 | 1286.43 | ||
11 | TRUE | 29-06-2020 | 114534.00 | ||
12 | TRUE | 29-06-2020 | 114534.00 | ||
13 | TRUE | 27-07-2020 | 275940.00 | ||
14 | TRUE | 27-07-2020 | 275940.00 | ||
15 | TRUE | 12-12-2020 | 13650.00 | ||
16 | TRUE | 12-12-2020 | 13650.00 | ||
17 | FALSE | 05-01-2021 | 32193.00 | ||
18 | FALSE | 04-07-2020 | 32340.00 | ||
19 | FALSE | 05-07-2020 | 32340.00 | ||
20 | FALSE | 18-08-2020 | 2604.00 | ||
21 | FALSE | 13-03-2020 | 2633.00 | ||
Reconcile |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E27:F1048576,E1:F19 | Expression | =COUNTIFS($B$1:$B$1428,$B1,$F$1:$F$1428,"<"&$F1+0.5,$F$1:$F$1428,">"&$F1-0.5)=1 | text | NO |