Forum Discussion
Dynamically auto-populate list based on cell values
Hi I wondered if anyone could possibly help. In my quest to make a more dynamic assessment system for my school, I'm stuck on a formula. I've searched and search and just can't quite find exactly ...
Let's say the names are in B2:B100 and the STRETCH/PAUSE values in J2:J100 on a sheet named Student Sheet.
On another sheet in for example A2 to list the STRETCH students:
=FILTER('Student Sheet'!B2:B100, 'Student Sheet'!J2:J100="STRETCH", "")
And in for example C2 to list the PAUSE students:
=FILTER('Student Sheet'!B2:B100, 'Student Sheet'!J2:J100="PAUSE", "")
The formulas will spill to as many cells as needed.
