olivergs1982
New Member
- Joined
- Jun 29, 2018
- Messages
- 9
Ahoy Hoy, struggling with how to do something and whether it's even possible. I'm importing data from another source into a new workbook and in this workbook and employee has a line for their job for the entier year, all 365 days. On days when they're on leave a letter is placed into that particular day on the line. I have already managed to come up with a sheet where the employee can enter their employee pin and it brings up their calendar only. I just wondered if there was a way to have it do this and only show the boxes that have had something entered into them. Basically I just want to show the entries on the line and not the full line.
This is the formula I'm using which imports everything for that employee only and for everything in their calendar for the year.
=iFERROR(ARRAY_CONSTRAIN(ARRAYFORMULA(INDEX(Sheet5!AB$3:AB$1000, SMALL(IF($A$5=Sheet5!$B$3:$B$1000, ROW(Sheet5!$B$3:$B$1000)-ROW(Sheet5!$A$3)+1), ROW(1:1)))), 1, 1),"")
This is the source data:
Any suggestions that don't involve VBA etc.?
Thanks
This is the formula I'm using which imports everything for that employee only and for everything in their calendar for the year.
=iFERROR(ARRAY_CONSTRAIN(ARRAYFORMULA(INDEX(Sheet5!AB$3:AB$1000, SMALL(IF($A$5=Sheet5!$B$3:$B$1000, ROW(Sheet5!$B$3:$B$1000)-ROW(Sheet5!$A$3)+1), ROW(1:1)))), 1, 1),"")
This is the source data:
Any suggestions that don't involve VBA etc.?
Thanks