excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi,
is it possible by formula to check and write when the last time a number/value repeated?
example:
is it possible by formula to check and write when the last time a number/value repeated?
example:
test | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | date | # | last time appeared | before last time | ||
2 | 15/04/2022 | 6862 | 02/04/2022 | 24/03/2022 | ||
3 | 14/04/2022 | 8336 | x | x | ||
4 | 13/04/2022 | 5741 | x | x | ||
5 | 12/04/2022 | 6324 | x | x | ||
6 | 11/04/2022 | 5414 | 27/03/2022 | x | ||
7 | 10/04/2022 | 3336 | x | x | ||
8 | 09/04/2022 | 7384 | x | x | ||
9 | 08/04/2022 | 1315 | x | x | ||
10 | 07/04/2022 | 2172 | x | x | ||
11 | 06/04/2022 | 6617 | x | x | ||
12 | 05/04/2022 | 3323 | x | x | ||
13 | 04/04/2022 | 6728 | x | x | ||
14 | 03/04/2022 | 5738 | x | x | ||
15 | 02/04/2022 | 6862 | x | x | ||
16 | 01/04/2022 | 6483 | x | x | ||
17 | 31/03/2022 | 3172 | x | x | ||
18 | 30/03/2022 | 5582 | x | x | ||
19 | 29/03/2022 | 8648 | x | x | ||
20 | 28/03/2022 | 6452 | x | x | ||
21 | 27/03/2022 | 5414 | x | x | ||
22 | 26/03/2022 | 4647 | x | x | ||
23 | 25/03/2022 | 5575 | x | x | ||
24 | 24/03/2022 | 6862 | x | x | ||
test |