=IF(ROWS(B$10:B10)>$C$2,"",INDEX(Task2.0!A$2:A$3500,SMALL(IF(Task2.0!$A$2:$A$3500=$B$2,IF(Task2.0!$H$2:$H$3500<=$E$2,IF(Task2.0!$H$2:$H$3500>=$D$2,ROW(Task2.0!$H$2:$H$3500)-ROW(Task2.0!$H$2)+1)),ROWS(B$10:B10))))
Can someone tell me what I am missing in the array formula above? I am receiving an error saying that I have too few arguments. I am trying to show the tasks based on the project ID and a date range.
<tbody>
</tbody>
Sheet - Task2.0
Column A = ID
Column H = Date
Can someone tell me what I am missing in the array formula above? I am receiving an error saying that I have too few arguments. I am trying to show the tasks based on the project ID and a date range.
B | C | D | E | |
2 | ID | Count ifs | Date 1 | Date 2 |
1 | Formula | 8/21/18 | 9/30/18 | |
10 | Array formula | Array formula | Array formula | Array formula |
<tbody>
</tbody>
Sheet - Task2.0
Column A = ID
Column H = Date