I have 8 questions (A - H) and 5 answers per question (1 - 5) - so a total of 40 possible answers.
Using PERMUT(8,5), I know there are 6,720 permutations of answers.
I now need to fill a matrix of 840 rows and 8 columns (Question ID) with the 6,720 permutations.
I want to fill them with an Answer ID (there are 40 answers) - A1, A2, A3, A4, A5....B1, B2, B3, B4, B5....and so on,.
Does anyone have a solution to this? Ideally, I would like a formula as opposed to VBA as I'm a little out of my depth when it comes to VBA code. However, I'll take whatever I can get!
Thanks in advance.
Using PERMUT(8,5), I know there are 6,720 permutations of answers.
I now need to fill a matrix of 840 rows and 8 columns (Question ID) with the 6,720 permutations.
I want to fill them with an Answer ID (there are 40 answers) - A1, A2, A3, A4, A5....B1, B2, B3, B4, B5....and so on,.
Does anyone have a solution to this? Ideally, I would like a formula as opposed to VBA as I'm a little out of my depth when it comes to VBA code. However, I'll take whatever I can get!
Thanks in advance.