forest1959
New Member
- Joined
- Mar 16, 2010
- Messages
- 30
- Office Version
- 2016
- Platform
- Windows
Hi All
I know this will be pretty straight forward, but i'm struggling to ask the web the right question..
I have an array formula that brings back an "order number" in column E, based on the order date in column A
{=IF(ROWS(A$35:A35)>COUNTIF(Timesheets!$A2:$A2000,$E$31),"",INDEX(Timesheets!$E2:$E2000,SMALL(IF(Timesheets!$A2:$A2000=$E$31,ROW(Timesheets!$A2:$A2000)-ROW(Timesheets!$A$2)+1),ROWS(A$35:A35))))}
I just need to add another criteria based on the employee's name populated in column C
Below is an example of the results i'm looking for
<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
regards
Paul
I know this will be pretty straight forward, but i'm struggling to ask the web the right question..
I have an array formula that brings back an "order number" in column E, based on the order date in column A
{=IF(ROWS(A$35:A35)>COUNTIF(Timesheets!$A2:$A2000,$E$31),"",INDEX(Timesheets!$E2:$E2000,SMALL(IF(Timesheets!$A2:$A2000=$E$31,ROW(Timesheets!$A2:$A2000)-ROW(Timesheets!$A$2)+1),ROWS(A$35:A35))))}
I just need to add another criteria based on the employee's name populated in column C
Below is an example of the results i'm looking for
Criteria 1 | Criteria 2 | Results | |||
05/04/2019 | Brian | 3456 | |||
5678 | |||||
31/03/2019 | Brian | 1234 | |||
31/03/2019 | Chris | 2345 | |||
05/04/2019 | Brian | 3456 | |||
05/04/2019 | Chris | 4567 | |||
05/04/2019 | Brian | 5678 | |||
05/04/2019 | Chris | 6789 |
<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>
regards
Paul