samedi 18 juin 2022

How to compile a list of other lists by checkbox?

I'm trying to write a cell formula which can essentially create a single playlist of songs.

Currently the songs are grouped by decade, but I'd like to be able to see a single list of everything that has been ticked.

I tried an array formula, but it only returned the first ticked song. Plus not sure how to make the array formula include the adjacent lists.

Attempt 1

I tried a FILTER function, it works for one list of songs, but I don't know how to get it to append the other lists on the end.

Attempt 2

Could I use a QUERY function? Not sure how though.

Many thanks!

Song lists




Aucun commentaire:

Enregistrer un commentaire