Susanna123
New Member
- Joined
- Mar 3, 2022
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hi All,
I have come across another issue while practicing with a Leave Tracker (without Macros).
I have a calendar across a sheet (January to December) and I have inserted an Array Formula in 1-Jan-22 to show when a Holiday has been taken (according to the Leave Records in another sheet).
The problem is that the calendar does not show any leave.
The Array formula is Active "{}" through out the calendar but maybe I made a mistake when copying the array formula as the cell $B7 remains the same in all cells formulas instead of the second reference changing into $B8,$B9,$B10 etc..
I am not sure if that is the reason why nothing is showing. If it is, how does one copy an Array Formula step by step?
Here's a link to the Document: CLICK HERE
I apologise in advance if my problems are silly but thanks.
I have come across another issue while practicing with a Leave Tracker (without Macros).
I have a calendar across a sheet (January to December) and I have inserted an Array Formula in 1-Jan-22 to show when a Holiday has been taken (according to the Leave Records in another sheet).
The problem is that the calendar does not show any leave.
Excel Formula:
{=IFERROR(INDEX(Records!$D$2:$D$150,MATCH(1,IF(C$6>=Records!$E$2:$E$150,IF(C$6<=Records!$F$2:$F$150,IF($B7=Records!$B$2:$B$150,1))),0)),"")}
The Array formula is Active "{}" through out the calendar but maybe I made a mistake when copying the array formula as the cell $B7 remains the same in all cells formulas instead of the second reference changing into $B8,$B9,$B10 etc..
I am not sure if that is the reason why nothing is showing. If it is, how does one copy an Array Formula step by step?
Here's a link to the Document: CLICK HERE
I apologise in advance if my problems are silly but thanks.