tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
Here is my data:
In cell G1, I type:
and enter it as an ARRAY formula.
I expected the result to be 1 but instead it returned #N/A.
What is wrong?
What I am trying to match is the condition a in Column E and if the date is less than or equal to 3 workdays after the date in Column D.
Thanks
EDIT SORTED:
Should be:
Rich (BB code):
Col A Col B Col D Col E
01/01/2010 a 31/12/2009 a 02/01/2010 b 01/01/2010 b 03/01/2010 c 02/01/2010 c 04/01/2010 d 03/01/2010 d
<tbody>
</tbody>
In cell G1, I type:
Rich (BB code):
=MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4,3)),0)
and enter it as an ARRAY formula.
I expected the result to be 1 but instead it returned #N/A.
What is wrong?
What I am trying to match is the condition a in Column E and if the date is less than or equal to 3 workdays after the date in Column D.
Thanks
EDIT SORTED:
Should be:
Rich (BB code):
=MATCH(1,(B1=E1:E4)*(A1<=WORKDAY(D1:D4+0,3+0)),0)
Last edited: