Forum Discussion
Solved
Pull values from range to calendar w/ criteria.
Hi,
Banging my head against a wall trying to pull values (Shift Group) from a range into a calendar based on criteria employee name in Row 1 and the relevant dates in Column U in the pictured example. I basically want to fill out who worked where on each date. Any help is greatly appreciated!
(FYI, using Office 365 on Mac.)
In V2:
=FILTER($S$2:$S$1000, ($Q$2:$Q$1000=V$1)*($R$2:$R$1000=$U2), "")
Fill down and to the right.
2 Replies
In V2:
=FILTER($S$2:$S$1000, ($Q$2:$Q$1000=V$1)*($R$2:$R$1000=$U2), "")
Fill down and to the right.
- Awesome! I thought about trying to use FILTER, but just couldn't work it out. Thanks a lot!
