Hi all,
Happy New Year, this is my first post in 2022.
I have two worksheets I'm working with.
worksheet one is titled KPI Data - MY22 ONLY
It is comprised of a list of unique data starting at F3 and a date starting at I3.
The other worksheet (CR 11.20 to 1.9) is comprised of data starting at A2 and a date starting at B2.
What I'm trying to do is match the data in KPI Data - MY22 ONLY with the data in CR 11.20 to 1.9, the kicker is that I'm looking for the date in column B that is closest (+/-) to the date in column I, then return the difference between those two dates in KPI Data - MY22 ONLY Column C.
I sure hope that makes sense
I'm only pasting the first 100 lines of data. There is actually 21,182, so you may not find a match.
Happy New Year, this is my first post in 2022.
I have two worksheets I'm working with.
worksheet one is titled KPI Data - MY22 ONLY
It is comprised of a list of unique data starting at F3 and a date starting at I3.
The other worksheet (CR 11.20 to 1.9) is comprised of data starting at A2 and a date starting at B2.
What I'm trying to do is match the data in KPI Data - MY22 ONLY with the data in CR 11.20 to 1.9, the kicker is that I'm looking for the date in column B that is closest (+/-) to the date in column I, then return the difference between those two dates in KPI Data - MY22 ONLY Column C.
I sure hope that makes sense
I'm only pasting the first 100 lines of data. There is actually 21,182, so you may not find a match.
Book1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Data | Date | ||
2 | WA1EAAFY5N2027089 | 11/20/2021 | ||
3 | WAUC4CF51NA004434 | 11/20/2021 | ||
4 | WAUCBCF56NA008887 | 11/20/2021 | ||
5 | WA1EAAFY4N2032087 | 11/20/2021 | ||
6 | WA1EECF33N1015033 | 11/20/2021 | ||
7 | WA1GAAFY0N2034265 | 11/20/2021 | ||
8 | WA1LAAGE4NB006701 | 11/20/2021 | ||
9 | WAU92BF2XNN014310 | 11/20/2021 | ||
10 | WAU72BF20NN014680 | 11/20/2021 | ||
11 | WA1GAAFY0N2029101 | 11/20/2021 | ||
12 | WA1AUCF38N1037885 | 11/20/2021 | ||
13 | WA1BAAFY2M2138202 | 11/20/2021 | ||
14 | WA1EECF38N1016615 | 11/20/2021 | ||
15 | WA1LJBF75ND003545 | 11/20/2021 | ||
16 | WAUABCF53NA005548 | 11/20/2021 | ||
17 | WAUW4GF52NN001023 | 11/20/2021 | ||
18 | WA1BNAFY9L2035619 | 11/20/2021 | ||
19 | WA1EECF31N1017976 | 11/20/2021 | ||
20 | WA1EECF34N1031368 | 11/20/2021 | ||
21 | WA12AAGE2NB009236 | 11/20/2021 | ||
22 | WAUBBCF57NA003774 | 11/20/2021 | ||
23 | WAUABCF50NA004714 | 11/20/2021 | ||
24 | WA1DECF39N1033130 | 11/20/2021 | ||
25 | WA15AAFY3N2004927 | 11/20/2021 | ||
26 | WA1DECF37N1018142 | 11/20/2021 | ||
27 | WA1EAAFY8N2005720 | 11/20/2021 | ||
28 | WA1VAAF76HD026727 | 11/20/2021 | ||
29 | WA1AAAFY8M2130598 | 11/20/2021 | ||
30 | WA1LAAGE7NB009477 | 11/20/2021 | ||
31 | WA124AFY3N2028932 | 11/20/2021 | ||
32 | WA1AAAFY7M2116885 | 11/20/2021 | ||
33 | WA1LAAGEXNB009070 | 11/20/2021 | ||
34 | WA1EAAFY8N2026938 | 11/20/2021 | ||
35 | WAUEJBFW7N7003192 | 11/20/2021 | ||
36 | WA1B4AFYXN2039040 | 11/20/2021 | ||
37 | WAUH3DGY4NA005116 | 11/20/2021 | ||
38 | WA1EECF32N1007912 | 11/20/2021 | ||
39 | WA1AAAGE9NB005552 | 11/20/2021 | ||
40 | WA1EECF39N1019149 | 11/20/2021 | ||
41 | WA1C4AFYXM2091111 | 11/20/2021 | ||
42 | WA1EECF3XN1018723 | 11/20/2021 | ||
43 | WAUCBCF50NA006083 | 11/20/2021 | ||
44 | WA1EAAFY5N2016741 | 11/20/2021 | ||
45 | WAUABCF57NA006055 | 11/20/2021 | ||
46 | WA1AAAGE7NB010961 | 11/20/2021 | ||
47 | WAUY4GF57NN001379 | 11/20/2021 | ||
48 | WA1AAAGE0NB010834 | 11/20/2021 | ||
49 | WA1B4AFY6N2031260 | 11/20/2021 | ||
50 | WA1EAAFYXN2026116 | 11/20/2021 | ||
51 | WA1LAAGE5NB011759 | 11/20/2021 | ||
52 | WA1LJBF71ND001209 | 11/20/2021 | ||
53 | WA1EECF32N1006260 | 11/20/2021 | ||
54 | WAUDFAF28MN076537 | 11/20/2021 | ||
55 | WA1C4AFY5N2031898 | 11/20/2021 | ||
56 | WAU8EAF87MN004902 | 11/20/2021 | ||
57 | WAUY4GF50NN001319 | 11/20/2021 | ||
58 | WA1VWBF79ND000089 | 11/20/2021 | ||
59 | WUAPCBF25NN900741 | 11/20/2021 | ||
60 | WA1AAAFY2M2137871 | 11/20/2021 | ||
61 | WAUH3DGYXNA004004 | 11/20/2021 | ||
62 | WA1EECF38N1029722 | 11/20/2021 | ||
63 | WA14AAFY0N2000863 | 11/20/2021 | ||
64 | WAUABCF54MA030859 | 11/20/2021 | ||
65 | WA1AJBF72ND004157 | 11/20/2021 | ||
66 | WA1EAAFY4N2016407 | 11/20/2021 | ||
67 | WA1AUCF3XN1041145 | 11/20/2021 | ||
68 | WA1GAAFY1N2031035 | 11/20/2021 | ||
69 | WAU8SAF89MN027459 | 11/20/2021 | ||
70 | WAUV2BF28NN014031 | 11/20/2021 | ||
71 | WA1EECF37N1032093 | 11/20/2021 | ||
72 | WAUY4GF5XNN001358 | 11/20/2021 | ||
73 | WUA1CBF22NN901254 | 11/20/2021 | ||
74 | WA1DECF38N1031496 | 11/20/2021 | ||
75 | WA1FAAFY1N2004137 | 11/20/2021 | ||
76 | WA1CVBF11ND006359 | 11/20/2021 | ||
77 | WA1EECF30N1040987 | 11/20/2021 | ||
78 | WA1EECF33N1035217 | 11/20/2021 | ||
79 | WA1GAAFYXN2031857 | 11/20/2021 | ||
80 | WA1LAAGE5NB009381 | 11/20/2021 | ||
81 | WA1LAAGE9NB009240 | 11/20/2021 | ||
82 | WA1VXBF71ND003694 | 11/20/2021 | ||
83 | WUAKBAFX3N7900373 | 11/20/2021 | ||
84 | WA1EECF35N1030732 | 11/20/2021 | ||
85 | WA1AUCF35N1041408 | 11/20/2021 | ||
86 | WA1GAAFY6N2029264 | 11/20/2021 | ||
87 | WAUFJBFW1N7004424 | 11/20/2021 | ||
88 | WA1EECF38N1030255 | 11/20/2021 | ||
89 | WAUY4GF55NN001168 | 11/20/2021 | ||
90 | WA1B4AFY1N2035491 | 11/20/2021 | ||
91 | WA1EECF39N1033164 | 11/20/2021 | ||
92 | WA1GAAFY4N2029215 | 11/20/2021 | ||
93 | WA12AAGE2MB015097 | 11/20/2021 | ||
94 | WAUBBAF41NN003483 | 11/20/2021 | ||
95 | WA1AUCF3XN1037595 | 11/20/2021 | ||
96 | WA1EECF35N1033307 | 11/20/2021 | ||
97 | WA1GAAFY5N2016232 | 11/20/2021 | ||
98 | WA1LXBF78ND003554 | 11/20/2021 | ||
99 | WAUABCF53NA005629 | 11/20/2021 | ||
100 | WAUCBCF55MA062504 | 11/20/2021 | ||
101 | WAUE3BF22NN013812 | 11/20/2021 | ||
CR 11.20 to 1.9 |
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
2 | Data | Date | Difference | ||
3 | WA1EAAFY9N2046096 | 12/31/2021 | |||
4 | WA1DECF36N1057997 | 12/31/2021 | |||
5 | WA1DECF35N1047025 | 12/31/2021 | |||
6 | WAUABAF49NN004604 | 12/31/2021 | |||
7 | WA1CWBF10ND009296 | 12/31/2021 | |||
8 | WA1EABFY5N2047235 | 12/31/2021 | |||
9 | WA1FAAFY1N2043486 | 12/31/2021 | |||
10 | WAUGUDGY6NA018247 | 12/31/2021 | |||
11 | WAUHUDGY6NA018348 | 12/31/2021 | |||
12 | WAUW4GF55NN001677 | 12/31/2021 | |||
13 | WA1C4AFYXN2041519 | 12/31/2021 | |||
14 | WAU72BF24NN013175 | 12/31/2021 | |||
15 | WA1EECF30N1044117 | 12/31/2021 | |||
16 | WA1AAAGE9NB011142 | 12/31/2021 | |||
17 | WAUCBAF41NN002421 | 12/31/2021 | |||
18 | WA1DECF37N1044238 | 12/31/2021 | |||
19 | WA1A4AFY3N2037805 | 12/31/2021 | |||
20 | WAUFACF56NA013474 | 12/31/2021 | |||
21 | WAUDAAF4XNN004188 | 12/31/2021 | |||
22 | WA1AAAGE3NB013453 | 12/31/2021 | |||
23 | WAUEAAF47NN004072 | 12/31/2021 | |||
24 | WA1LAAGE3NB013090 | 12/31/2021 | |||
25 | WA1AAAGE4NB012943 | 12/31/2021 | |||
26 | WA1FVBF16ND006466 | 12/31/2021 | |||
27 | WAUYAGF53NN001727 | 12/31/2021 | |||
28 | WA1EAAFY2N2046781 | 12/31/2021 | |||
29 | WA1EECF37N1049749 | 12/31/2021 | |||
30 | WA1EECF31N1051707 | 12/31/2021 | |||
31 | WA17AAF40NA006601 | 12/31/2021 | |||
32 | WA1LAAGE6NB011446 | 12/31/2021 | |||
33 | WU1ARBF10ND009029 | 12/31/2021 | |||
34 | WA1DECF31N1054067 | 12/31/2021 | |||
35 | WA1DECF30N1053587 | 12/31/2021 | |||
36 | WA1EAAFY9N2044123 | 12/31/2021 | |||
37 | WAUPFBF24NN018560 | 12/31/2021 | |||
38 | WAUAUDGY6NA018142 | 12/31/2021 | |||
39 | WA15AAFY7N2045304 | 12/31/2021 | |||
40 | WA1LXBF78ND005630 | 12/31/2021 | |||
41 | WA124AFY5N2038930 | 12/31/2021 | |||
42 | WA124AFY7N2042414 | 12/31/2021 | |||
43 | WA134AFY7N2037833 | 12/31/2021 | |||
44 | WAUEAAF48NN004078 | 12/31/2021 | |||
45 | WAUP4AF59NA010827 | 12/31/2021 | |||
46 | WA1LXBF73ND005843 | 12/31/2021 | |||
47 | WA1FAAFY9N2045860 | 12/31/2021 | |||
48 | WAUAHBFW1N7902379 | 12/31/2021 | |||
49 | WA1AUCF31N1020426 | 12/31/2021 | |||
50 | WA1EAAFYXN2044437 | 12/31/2021 | |||
51 | WA1EAAFY5N2045110 | 12/31/2021 | |||
52 | WAUV2BF23NN008833 | 12/31/2021 | |||
53 | WAUW4GF59NN001732 | 12/31/2021 | |||
54 | WA1LJBF72ND004345 | 12/31/2021 | |||
55 | WAUABCF55NA011240 | 12/31/2021 | |||
56 | WA1FVBF10ND006544 | 12/31/2021 | |||
57 | WA1LXBF7XND005256 | 12/31/2021 | |||
58 | WA1EECF35N1051757 | 12/31/2021 | |||
59 | WAUCBCF5XNA011338 | 12/31/2021 | |||
60 | WA1B4AFY0N2039404 | 12/31/2021 | |||
61 | WAUABCF50NA006222 | 12/31/2021 | |||
62 | WA1C4AFY8N2040109 | 12/31/2021 | |||
63 | WAUAUDGYXNA030102 | 12/31/2021 | |||
64 | WA12ABGE3NB008487 | 12/31/2021 | |||
65 | WA11AAGE2NB013850 | 12/31/2021 | |||
66 | WA1DECF31N1021702 | 12/31/2021 | |||
67 | WA1LJBF7XND005291 | 12/31/2021 | |||
68 | WA1DECF38N1029120 | 12/31/2021 | |||
69 | WAU92BF20NN014235 | 12/31/2021 | |||
70 | WAUFJBFW5N7004149 | 12/31/2021 | |||
71 | WA1EECF36N1053324 | 12/31/2021 | |||
72 | WA1LXBF7XND005807 | 12/31/2021 | |||
73 | WAUEAAF40NN004074 | 12/31/2021 | |||
74 | WA1EECF3XN1051222 | 12/31/2021 | |||
75 | WA124AFY4N2042645 | 12/31/2021 | |||
76 | WA15AAFY6N2046816 | 12/31/2021 | |||
77 | WA1B4AFY3N2044905 | 12/31/2021 | |||
78 | WA1BVBF13ND009839 | 12/31/2021 | |||
79 | WA1EECF3XN1045128 | 12/31/2021 | |||
80 | WA1EECF39N1045038 | 12/31/2021 | |||
81 | WA1VXBF70ND005727 | 12/31/2021 | |||
82 | WAUBBAF45NN003714 | 12/31/2021 | |||
83 | WA1FAAFY6N2043001 | 12/31/2021 | |||
84 | WAUFACF51NA012880 | 12/31/2021 | |||
85 | WA1B4AFY1N2040545 | 12/31/2021 | |||
86 | WAUCJBFW6N7001585 | 12/31/2021 | |||
87 | WA1DECF34N1043919 | 12/31/2021 | |||
88 | WA1LJBF78ND006262 | 12/31/2021 | |||
89 | WA1CWBF15ND008354 | 12/31/2021 | |||
90 | WA1EAAFY7N2044895 | 12/31/2021 | |||
91 | WAUFJBFWXN7003790 | 12/31/2021 | |||
92 | WA1B4AFY8N2040414 | 12/31/2021 | |||
93 | WA1VABGE7NB015505 | 12/31/2021 | |||
94 | WA1LXBF77ND005568 | 12/31/2021 | |||
95 | WA1LJBF75ND005425 | 12/31/2021 | |||
96 | WAUCBCF51NA011373 | 12/31/2021 | |||
97 | WA1DECF39N1032057 | 12/31/2021 | |||
98 | WA1FAAFYXN2043213 | 12/31/2021 | |||
99 | WAUD3BF2XNN016596 | 12/31/2021 | |||
100 | WA1LABGE1NB007259 | 12/31/2021 | |||
101 | WA1EECF3XN1048353 | 12/31/2021 | |||
102 | WAUEAAF49NN002551 | 12/31/2021 | |||
KPI Data - MY22 ONLY |