https://classes.soe.ucsc.edu/cmps115...sionTables.htm

6. Simplify the table.
•Determine if there are rules (columns) that have the same actions. If so, determine if these are rules that are identical except for one condition and for that one condition, all possible values of this condition are present in the rules in these columns.


Hi, I have a general question. I want to build an Excel-based VBA tool to double check Decision Tables. Now I need help how I can write code to check if the table has been simplified. I do NOT ask for help on writing code, I am asking for the ideas. What is a good way to let the code know " if these are rules that are identical except for one condition and for that one condition, all possible values of this condition are present in the rules in these columns".

Thank you very much!