Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 172
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Looking for a formula to match the dates and if "Zone Check" equals "Yes" within that date range, return "Ineligible" and "Eligible" if Zone Check is "No"
1st Answer will be Eligible as All Zone Check were "No"
1st Answer will be Eligible as All Zone Check were "No"
Date | Zone Check | Date | Zone Check |
21/07/2020 | eligible | 21/07/2020 | No |
22/07/2020 | 21/07/2020 | No | |
23/07/2020 | 21/07/2020 | No | |
24/07/2020 | 21/07/2020 | No | |
21/07/2020 | No | ||
21/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | Yes | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
22/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
23/07/2020 | No | ||
24/07/2020 | Yes | ||
24/07/2020 | No | ||
24/07/2020 | No |