Originally Posted by
Kenneth Hobs
I would suggest making your logic a bit more clear. Obviously, checkbox 1 and 2 can both be checked so that needs optionboxes too instead I suspect. IF one of the checkboxes are checked, then I would guess that you may then want to include all rows in columns A and B that match both the first set of options boxes and the 2nd set of option boxes criterion. Another Idea to consider is to let the user select the options from the data in comboboxes. I would do a combobox for the column C and one for the Column D. Those are really easy to do. This would handle the case where later you add another option say 5 for the column D data. That combobox would list 1,2,3,5.