Here’s the formula:
=IF([checkbox]=TRUE, FILTER([all data], [column to filter]=[criteria]), [all data])
❤️ and follow for daily tips!
🗂️ Save this post for future reference!
👯 Share it with a friend!
🎁 Get Excel Templates, PDF Cheat Sheets, Trackers, and Trainings at the link in our bio!
🎯 Follow us on Instagram, YouTube, TikTok, and more at the link in our bio!
#excel #shortcuts #cheat #sheet #spreadsheet