Fellas,
I have 2000 service order by VIN's in column A (sheet1) with different closed dates (example, VIN# 111 service order completed on 1 Jun2019.
In the sheet2 I need to find if VIN 111 when is next service order open after 1 Jun or next one (see example below:
sheet1:
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
So what I need is to find out is, VIN#111 closed date (sheet1) and next date open if its same day OR next one.
example: VIN#111, closed service order 1 Jun 2019 (sheet 1), next open is 1 Jun 2019 (sheet 2) and next one on line which is 6 Jun 2019.
Looking forward for reply,
I have 2000 service order by VIN's in column A (sheet1) with different closed dates (example, VIN# 111 service order completed on 1 Jun2019.
In the sheet2 I need to find if VIN 111 when is next service order open after 1 Jun or next one (see example below:
sheet1:
a | b |
VIN | date, Service order closed |
111 | 1 Jun2019 |
112 | 5 Jun 2019 |
113 | 6 Jun 2019 |
<tbody>
</tbody>
Sheet 2
a | b | c | d | f | g |
VIN | date, open (1) | date, open (2) | date, open (3) | date, open (4) | date, open (5) |
111 | 1 Jun 2019 | 6 Jun 2019 | 12 Jun 2019 | ||
112 | 5 Jun 2019 | 6 Jun 2019 | 15 Jun 19 | ||
113 | 6 Jun 2019 | 16 Jun 2019 | |||
<tbody>
</tbody>
So what I need is to find out is, VIN#111 closed date (sheet1) and next date open if its same day OR next one.
example: VIN#111, closed service order 1 Jun 2019 (sheet 1), next open is 1 Jun 2019 (sheet 2) and next one on line which is 6 Jun 2019.
Looking forward for reply,