uswyne
Board Regular
- Joined
- Jul 27, 2017
- Messages
- 78
- Office Version
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
| Table 1 | ||||||
| Name | Uniform | Issue Date | Due Date | Shoe | Issue Date | Due Date |
| AAA | 2 | 31-Dec-18 | 31-Dec-18 | 1 | 01-Jan-18 | 01-Jan-19 |
| BBB | 2 | 30-Nov-17 | 30-Nov-18 | 1 | 31-Dec-17 | 31-Dec-18 |
| CCC | 2 | 25-Nov-17 | 25-Nov-18 | 1 | 30-Novv-17 | 30-Nov-18 |
<tbody>
</tbody>
I need a formula to extract data from table 1 in to table given below.
| A | B | C | D |
| Nov-18 | Dec-18 | Jan-19 | |
| Uniform | 02 (?) | 01 (?) | 00 (?) |
| Shoes | 01 (?) | 01 (?) | 01 (?) |
<tbody>
</tbody>
Need help
