SOLVED

# Pull values from range to calendar w/ criteria.

Copper Contributor

# 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.)

2 Replies
best response confirmed by TDEP365 (Copper Contributor)
Solution

# Re: Pull values from range to calendar w/ criteria.

In V2:

=FILTER(\$S\$2:\$S\$1000, (\$Q\$2:\$Q\$1000=V\$1)*(\$R\$2:\$R\$1000=\$U2), "")

Fill down and to the right.

# Re: Pull values from range to calendar w/ criteria.

Awesome! I thought about trying to use FILTER, but just couldn't work it out. Thanks a lot!
1 best response

Accepted Solutions
best response confirmed by TDEP365 (Copper Contributor)
Solution

# Re: Pull values from range to calendar w/ criteria.

In V2:

=FILTER(\$S\$2:\$S\$1000, (\$Q\$2:\$Q\$1000=V\$1)*(\$R\$2:\$R\$1000=\$U2), "")

Fill down and to the right.