GOOGLE SHEETS - QUERY FUNCTION TO FILTER DATA BASED ON SINGLE OR MULTIPLE SELECTIONS IN CHECKBOXES.

#googlesheets #excel #googlesheetstips
This video demonstrates how to use the QUERY function and filter it using a checkbox either based on a single selection or multiple selections in the checkboxes. We also demonstrate how to use the FILTER function to obtain values of the selected check boxes that are then used in the QUERY FUNCTION to filter the data required.
To support this channel, consider becoming a Patreon by clicking the link below.
/ topzontech
Also, watch query function basics and filtering data using a dropdown list
• Google sheets -Query F...
Also, watch query function basics and filtering data using a checkbox
• Google Sheet Query fun...

[@azlanmn5502]

This is really helpful! if we want to add checkboxes for other criteria, can it be done? thanks again!

[@toptechkit]

@Azian you could option to use a dropdown list instead of a checkboxes. Please view this video I did you could help explain the multiple criteria you are looking for. czcams.com/video/ciCnv1esTvI/video.html

[@azlanmn5502]

@@toptechkit thank you!