Check Box Help

[WiscCard]

I have a spreadsheet that is a consolidation of three separate lists. What I am looking to do is create 3 check boxes after company name that will notate which list it came from (in some cases it could have come for all three). CB stands for check box.
Example:
A1 B1 C1 D1
Co. Name Reg. Cert. Contr.
ABC Supply CB CB CB

Where it gets complicated is that once I am all done, I will need to be able to sort by the checkboxes. For example, I may need to filter out those that both have "Reg." and "Cert." checked or just those with "Contr." checked.
Any suggestions?

 

[Makrini]

hmm - This may be a long way (probably someone has a quicker one)

When you create each checkbox - rightclick the box - format control and set up a "Cell Link" into another cell in the same row.

This will mean when the box is checked - that cell is "True" and when not it is "false" - you can then filter via the new 3 cells in each row