Forum Discussion
Solved
Fill unique values across columns but repeation allowed in columns
Dear Members, I just wanted to create MCQ Quiz sheet. I submitted a sample screen shot. I found the unique values using unique command in column 'C'. Now i wanted to fill option 2,3,4(i.e F2,G2,H2...
Assuming your formula in C2 is =UNIQUE(B2:B11), in E2 and copy down as necessary:
=LET( r, ROWS(C$2#), k, INDEX(SORTBY(SEQUENCE(r), RANDARRAY(r)),SEQUENCE(,4)), INDEX(C$2#,k) )
Assuming your formula in C2 is =UNIQUE(B2:B11), in E2 and copy down as necessary:
=LET(
r, ROWS(C$2#),
k, INDEX(SORTBY(SEQUENCE(r), RANDARRAY(r)),SEQUENCE(,4)),
INDEX(C$2#,k)
)
Sir thanks for your immediate response.
It worked out pretty well as I expected.
Thanks once again for helping me out.
It means a lot..
It worked out pretty well as I expected.
Thanks once again for helping me out.
It means a lot..
- Glad I could help & Thanks for providing feedback