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