mattbnorris
New Member
- Joined
- Sep 17, 2019
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
So I have a table with a list of loads of different references with dates assigned to them and also 'yes' or 'no' assigned to them. I need to return the reference numbers if the date is in a specific period and they have 'yes' assigned.
Example
<tbody>
</tbody>
Example
Date | Ref | Status | Jan-Mar 2019 & Yes | ||
01/01/19 | #111 | Yes | #111 | ||
23/01/19 | #444 | Yes | #444 | ||
25/02/19 | #333 | No | #222 | ||
01/01/19 | #222 | Yes | #555 | ||
07/03/19 | #555 | Yes |
<tbody>
</tbody>