formula for checking and write when a value last time appeared?

[excelNewbie22]

hi,
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

 

[excelNewbie22]

peter: now you mention it in other post i test it, along with your explanation how to copy from the forum to excel
works great,
thank you!
really

 

[Peter_SSs]

You're welcome.