Okay I'll try to explain this the best I can...
I have table with Color, Job, and Many Passes. The Color and Job will never be duplicate (for instance there will never be Red and M 1 on two different rows)
The Pass dates are only the start dates and only go until the next Pass start date.
So using the example below, cell D14 should have the correct pass for the associated color, job and date. In this case Red and M1 on 8/31/2016 should yield Pass3.
Thanks for any help. I'm usually very good at getting stuff like this done, but this time it's really sending me for a loop.
I have table with Color, Job, and Many Passes. The Color and Job will never be duplicate (for instance there will never be Red and M 1 on two different rows)
The Pass dates are only the start dates and only go until the next Pass start date.
So using the example below, cell D14 should have the correct pass for the associated color, job and date. In this case Red and M1 on 8/31/2016 should yield Pass3.
| Excel 2013 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Color | Job | Pass 1 | Pass 2 | Pass 3 | Pass 4 | Pass 5 | ||
| 2 | Black | M 0 | 8/10/2016 | ||||||
| 3 | Green | M 2 | 8/9/2016 | ||||||
| 4 | Indigo | M 3 | 9/28/2016 | ||||||
| 5 | Orange | M 2 | 7/24/2017 | 8/7/2016 | 8/15/2016 | 9/5/2016 | 9/11/2016 | ||
| 6 | Red | M 1 | 7/24/2017 | 8/7/2016 | 8/15/2016 | 9/5/2016 | 9/11/2016 | ||
| 7 | Red | M 2 | 7/24/2016 | 8/10/2016 | 9/7/2016 | 9/29/2016 | 11/3/2016 | ||
| 8 | Red | M 0 | 6/27/2016 | 7/28/2016 | 8/25/2016 | ||||
| 9 | Violet | M 1 | 10/11/2016 | 11/15/2016 | 12/20/2016 | 1/24/2017 | |||
| 10 | White | M 0 | 10/18/2016 | 11/21/2016 | 12/28/2016 | 1/25/2017 | |||
| 11 | Yellow | M 3 | 10/25/2016 | 11/28/2016 | 1/4/2017 | 2/2/2017 | |||
| 12 | |||||||||
| 13 | Color | Job | Date | Pass | |||||
| 14 | Red | M 1 | 8/31/2016 | ||||||
Sheet1 | |||||||||
Thanks for any help. I'm usually very good at getting stuff like this done, but this time it's really sending me for a loop.
