Is formula that will generate a table of possible combinations? I am working on an electronic summary form which helps professional learners understand how close (or far away) they are from achieving certification and what areas they need to work on.
For this section, I have five columns. Each column represents a different characteristic that must be met in order to achieve "Fidelity" or certification. Each characteristic is labeled either FIDELITY, APPROACHING FIDELITY or NO FIDELITY. The combination of all of those characteristics result in an overall determination. I have attached a sample with the overarching rules. Is there a formula that can generate all possible combinations? Could a pivot table do this? I'd like to avoid VBA if I can.
Thanks!
L
Bookmarks