vendredi 2 juin 2023

How can I filter each name in a column based on having at least one checked box on Google Sheets?

Here's what I have:

Column A lists names of volunteers.

Columns B to S consist entirely of checkboxes (with column headings).

I would like to use a formula elsewhere in the spreadsheet to filter out all volunteers that are serving in at least one area (as indicated by checkboxes ie. true/false). I would prefer not to use a helper column for this. Any help much appreciated.

Check out my sample here:

I tried using the filter function, sumif, sumproduct, nothing seems to work without getting extremely complicated or requiring a helper column.




Aucun commentaire:

Enregistrer un commentaire