Format a list in a table with calculations
Garsperdu
-
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention -
Hello,
I would like to create a list with names, but for this example, I will use letters and each one will meet all the others, knowing that they will always be arranged in groups of 3.
So I would like each (person) letter to meet all the other letters, for example for ABC (understand Antoine, Béa, Cindy), then ABD (Antoine, Béa, Daniel), ABE ABF ABG ABH ABI ABJ ABK ABL ABM ABN ABO and then obviously ACD ACE,… exhausting all the possible combinations in groups of 3.
Can you help me format this and how to automate this calculation without having to do it manually?
Thank you very much in advance from a total beginner