Checkbox filtering using words instead of numbers True/False

PuntingJawa

New Member
Joined
Feb 25, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I am fairly new to excel so please bare with me. I'm trying to make a checkbox in B2 create the "True/False" in A2. Then trying to make A2 activate a filter in all of C through F cells where True activates the filter for a specified word and False removes the filter. In this case I'm creating a filter for candy. So say the candy is Sweet, Salty, and Milk Chocolate. I want to be able to check the boxes with "Sweet" "Salty" "Chocolate" and have it pull up the products with the flavor combination. Is this even possible? I'll upload my data sheet when I get home in two hours on what it currently looks like.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

PuntingJawa

New Member
Joined
Feb 25, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Beaker Project 2.xlsx
ABCDEFGHIJK
1FlavorsChocolate TypeProductFlavor 1Flavor 2Flavor 3Flavor 4Chocolate type
2
3TRUETRUECandy Club: Spring Twists - Limited EditionSweetSaltyMILKCRUNCHYCHOCOLATE
4TRUETRUECandy Club: PB Malt Balls - Limited EditionSWEETPEANUT BUTTERCRUNCHY
5TRUETRUECandy Club: Mint Bunny Bark - Limited EditionCRUNCHYSWEETWHITE
6TRUECandy Club: Eggstra Special - Limited EditionGUMMYFRUITYSWEET
7TRUECandy Club: Creamsicle Taffy - Limited EditionCHEWYFRUITYSWEET
8TRUECandy Club: Coconut Haystacks - Limited EditionCHOCOLATEMILKCRUNCHY
9TRUECandy Club: Bunny Buddies - Limited EditionFRUITYCHEWYSWEET
10TRUESugar Free Milk Chocolate Coated AlmondsCHOCOLATEMILKCRUNCHY
11TRUESugar Free Dark Chocolate Coated AlmondsCHOCOLATEDarkCRUNCHY
12TRUECinnamon Roasted AlmondsCINNAMONcrunchySweet
13TRUECinnamon Roasted CashewsCINNAMONcrunchySweet
14TRUECinnamon Roasted PecansCINNAMONcrunchySweet
15TRUEPremium Slushy Mix - WatermelonSweetFruity
16TRUEPremium Slushy Mix - PomegranateSweetFruity
17TRUEPremium Slushy Mix - RaspberrySweetFruity
18TRUEPremium Slushy Mix - Pina ColadaSweetFruity
19TRUEPremium Slushy Mix - Strawberry DaiquiriSweetFruity
20TRUEPremium Slushy Mix - Peach MangoSweetFruity
21TRUEPremium Slushy Mix - SangriaSweetFruity
22Premium Slushy Mix - Cranberry AcaiSweetFruity
23Premium Slushy Mix - MargaritaSweetFruity
24Premium Slushy Mix - Blood OrangeSweetFruity
25Compartes: Vegan Organic Blueberry Almond Dark Chocolate Bar - BeautyChocolateDARKFRUITY
26Compartes: Vegan Organic 80% Pure Cocoa Dark Chocolate Bar - PureChocolatedark
27Compartes: Vegan Organic Mixed Nuts Sea Salt Dark Chocolate Bar - EnergyChocolateDARKNUTTY
28Compartes: Vegan Organic Strawberry Goji Acai Dark Chocolate Bar - SuperfoodCHocolateDARKFRUITY
29Compartes: Caramel Crunch Milk Chocolate BarCaramelMilkChocolate
30Compartes: Old Hollywood Smoked Sea Salt Dark Chocolate BarSaltyChocolateDark
31Compartes: Coffee Crunch Dark Chocolate BarCoffeeCrunchyChocolateDark
32Compartes: Chocolate Chip Cookies Milk Chocolate BarChocolatecrunchyMILK
33Compartes: Peanut Butter and Jelly Milk Chocolate BarChocolateCrunchyNuttyPeanut Butter
34Compartes: Blonde Bombshell Strawberry Champagne Dark Chocolate BarChocolateFruityDark
35Compartes: Tiramisu Milk Chocolate BarCoffeeMilkChocolate
36Compartes: California Love Dark Chocolate Salted Pretzel BarSaltyChocolateDARKCrunchy
37Compartes: Raspberry Rose Dark Chocolate BarChocolatedarkfruity
Filter
 

Watch MrExcel Video

Forum statistics

Threads
1,127,374
Messages
5,624,319
Members
416,020
Latest member
ANDREAC247

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top