Forum Discussion
Solved
Unique spilling behavior
Hello there. i have a document where i have many columns with only 3 i care about: groups, students, and scores. there are 9 groups with more that could be added, and each one has around 20 unique st...
Hi NasTMashups
Assuming I understood...
in F2:
=LET( uGroup, UNIQUE(B3:B13), cols, SEQUENCE(,COUNTA(uGroup)*2), IF(ISODD(cols), INDEX(uGroup,ROUNDUP(cols/2,0)), "") )
thank you so much!!!! this is exactly what i wanted!
Glad this helped & Thanks for providing feedback