Magoosball
Board Regular
- Joined
- Jun 4, 2017
- Messages
- 70
- Office Version
- 365
Below is a sample of my data
Table 1:
<tbody>
</tbody>
From the above data I need to write 3 formulas to get the answer table below:
Table 2:
<tbody>
</tbody>
Please note the formulas need to first find the employee number on table 2 in table 1 and the array of employment dates that match the employee number number.
The formula is looking to find the min and max from date for each employee that ins't blank in the 4th column. It is also looking to count the number of Non blank cells in column 4 for each employee
Thank you in advance!
Table 1:
From Date | To Date | Yes or blank | |
Employee 1 | |||
11/26/2001 | 12/8/2001 | Yes | |
1/7/2002 | 1/22/2002 | Yes | |
6/17/2002 | 7/15/2002 | ||
10/5/1995 | 1/1/2000 | Yes | |
Employee 2 | |||
10/21/2004 | 12/18/2004 | Yes | |
2/25/2005 | 3/4/2005 | ||
3/6/2005 | 3/26/2005 | Yes | |
1/8/2006 | 2/4/2006 | ||
2/23/2006 | 2/25/2006 | Yes | |
5/31/2006 | 6/5/2006 | ||
<tbody>
</tbody>
From the above data I need to write 3 formulas to get the answer table below:
Table 2:
Employee Number | Min "Yes" Date | Max "Yes" Date | Number of "Non blanks" |
Employee 1 | 10/05/1995 | 1/7/2002 | 3 |
Employee 2 | 10/21/2004 | 2/23/2006 | 3 |
<tbody>
</tbody>
Please note the formulas need to first find the employee number on table 2 in table 1 and the array of employment dates that match the employee number number.
The formula is looking to find the min and max from date for each employee that ins't blank in the 4th column. It is also looking to count the number of Non blank cells in column 4 for each employee
Thank you in advance!