Check Data2 with Data1, filter data range in data2 with criteria range in data1 (criteria is date in particular machid in data1 should be less than date in particular machid in data2). the required result highlighted in sample data.
| sample data.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | DATA1 | DATA2 | ||||||||
| 2 | SEQNO | MACHID | DATE | REF | MACHID | DATE | ||||
| 3 | 335767554 | S1BW000007 | 07-08-2023 | 411736400 | S1NB000090 | 01-08-2023 | ||||
| 4 | 335198158 | S1BW000007 | 07-08-2023 | 411736348 | S1NB000090 | 01-08-2023 | ||||
| 5 | 349167807 | S1NW000197 | 08-08-2023 | 411882284 | S1NG000080 | 02-08-2023 | ||||
| 6 | 320227555 | S1BJ000134 | 08-08-2023 | 411878596 | S1B2000153 | 02-08-2023 | ||||
| 7 | 319892934 | S1BJ000134 | 08-08-2023 | 411984633 | T1NW000240 | 03-08-2023 | ||||
| 8 | 297800931 | T1NW000225 | 10-08-2023 | 411948794 | T1NW000239 | 03-08-2023 | ||||
| 9 | 264266830 | S5NL000624 | 10-08-2023 | 412095570 | S1B2000159 | 04-08-2023 | ||||
| 10 | 360167640 | BHNZ000178 | 10-08-2023 | 412338287 | T1NW000273 | 07-08-2023 | ||||
| 11 | 264246969 | T1NW000225 | 10-08-2023 | 412338216 | S1BW000027 | 07-08-2023 | ||||
| 12 | 359686232 | T1NW000235 | 10-08-2023 | 412337372 | S1NB000199 | 07-08-2023 | ||||
| 13 | 359480336 | S1B2000159 | 10-08-2023 | 412335798 | S1NB000199 | 07-08-2023 | ||||
| 14 | 359568957 | T1NW000226 | 10-08-2023 | 412566061 | T1BW000292 | 09-08-2023 | ||||
| 15 | 359240064 | T1NW000221 | 10-08-2023 | 412541541 | S1NB000199 | 09-08-2023 | ||||
| 16 | 358983840 | S1BW000064 | 10-08-2023 | 412639932 | S1BW000007 | 10-08-2023 | ||||
| 17 | 359815139 | S1BW000105 | 10-08-2023 | 412639900 | S1BW000007 | 10-08-2023 | ||||
| 18 | 359007762 | T1NW000263 | 10-08-2023 | 412791749 | S1BW000027 | 11-08-2023 | ||||
| 19 | 359129020 | T1NW000218 | 11-08-2023 | 413216238 | S1B2000159 | 16-08-2023 | ||||
| 20 | 359128907 | T1NW000239 | 11-08-2023 | 413181096 | S1BW000287 | 16-08-2023 | ||||
| 21 | 300225532 | S5NL000624 | 14-08-2023 | 413163663 | S1NB000100 | 16-08-2023 | ||||
| 22 | 253881060 | S1NG000196 | 18-08-2023 | 413390541 | S1NB000138 | 18-08-2023 | ||||
| 23 | 271810425 | T1NW000210 | 19-08-2023 | 413390517 | S1NB000138 | 18-08-2023 | ||||
| 24 | 269920974 | S5NL000624 | 20-08-2023 | 413534177 | T1NW000251 | 19-08-2023 | ||||
| 25 | 413523633 | S1NB000138 | 19-08-2023 | |||||||
| 26 | 413523608 | S1NB000138 | 19-08-2023 | |||||||
| 27 | 413523165 | T1NW000210 | 19-08-2023 | |||||||
| 28 | 413494982 | S1BW000034 | 19-08-2023 | |||||||
| 29 | 413775865 | T1NW000224 | 22-08-2023 | |||||||
| 30 | 413757071 | T1NW000251 | 22-08-2023 | |||||||
| 31 | 413754461 | T1NW000251 | 22-08-2023 | |||||||
| 32 | 413750388 | S1NW000197 | 22-08-2023 | |||||||
| 33 | 413750337 | S1NW000197 | 22-08-2023 | |||||||
| 34 | 413747657 | S1BW000106 | 22-08-2023 | |||||||
| 35 | 413745015 | BHNZ000179 | 22-08-2023 | |||||||
| 36 | 413744393 | BHNZ000179 | 22-08-2023 | |||||||
Sheet1 | ||||||||||
