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?
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?