I need to create a table with the following structure:
applicant | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | 1 | A. C. D | E F | B 2 | C. B A. E D | F | 3 | C. A. F | E B D | .... | | | | | | | Basically, between A1 and 6, any letter from 1 to 6 can be. I need a macro (or some other method), through which I can produce this table with 200 applicants, where the tests are completely random. Does anyone know this?
You do not need a macro A single formula will: = CHAR (RANDBETWEEN (65 , 70))
Comments
Post a Comment