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 what I need.
All pupils are given either the value of STRETCH or PAUSE as can be seen in the image below. I need to, based on these values, create two lists on another sheet which are dynamically populated by these pupils; one list of pupils with STRETCH against their name and another list of pupils with PAUSE against their name.
Could anybody help? I’d be so grateful.
HiI 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 what I need.All pupils are given either the value of STRETCH or PAUSE as can be seen in the image below. I need to, based on these values, create two lists on another sheet which are dynamically populated by these pupils; one list of pupils with STRETCH against their name and another list of pupils with PAUSE against their name.Could anybody help? I’d be so grateful. Read More