hello you all,
i need some help with a formula
i have a list of ID numbers and corresponding dates on one table. on the other table i have a list of the same ID numbers but for each one there are several dates.
i need to find a way to find the closest date in the second table to the first list for each ID number.
e.g.
table 1
1 12.12.2006
2 15.07.2008
3 06.09.2012
4 08.10.2011
table 2
1 15.12.2001
1 16.01.2002
1 20.03.2004
1 05.04.2015
2 29.03.2015
2 16.05.2015
2 16.07.2016
2 17.07.2016
3 20.06.2001
3 30.01.2000
any ideas?
10X
i need some help with a formula
i have a list of ID numbers and corresponding dates on one table. on the other table i have a list of the same ID numbers but for each one there are several dates.
i need to find a way to find the closest date in the second table to the first list for each ID number.
e.g.
table 1
1 12.12.2006
2 15.07.2008
3 06.09.2012
4 08.10.2011
table 2
1 15.12.2001
1 16.01.2002
1 20.03.2004
1 05.04.2015
2 29.03.2015
2 16.05.2015
2 16.07.2016
2 17.07.2016
3 20.06.2001
3 30.01.2000
any ideas?
10X