I've been working on this for days and just can't figure it out. I tried different options and methods and just can't get it to work! I'm pretty new to VBA so that might be part of the issue.
I am trying to create a combo box that filters all my data based on three separate columns. These columns include either an 'X' or a blank in order to show whether or not the label applies to that specific row (Major, Minor, or New Launch). In most cases, two or more labels (of 3) apply to the same row (aka they are not mutually exclusive). I have the combobox populated with these options, but I can't make the filter work quite right.
I linked the combobox to one cell (B6) and used the following formulas to populate the advanced filter criteria.
=IF((B6="MINOR"), "X", "")
=IF((B6="MAJOR"), "X", "")
=IF((B6="NEW LAUNCH"), "X", "")
The problem is that the filter thinks I am looking for options that include all three labels as it is not recognizing that those cells are empty.
There is also a row specifying change level (1, 2, or 3) which is where the labels come from. Minor = 1, Major = 2, New Launch = 1,2, or 3. I also tried setting the filter based on that single column and couldn't get that to work either. I successfully filtered by 1, 2, or 3 (which was not exactly what I wanted, but I was willing to live with it), but I couldn't get the file to unfilter when [blank] cell was selected as the formulas linked to the combobox could not output a true blank (Excel sees it as 0).
Bookmarks