=INDEX(B2:D2,MODE(MATCH(B2:D2,B2:D2,0)))
can be used for example to count votes
can be used for example to count votes
Monday, February 6, 2017
Splitting a colum into multiple columns Excel
=INDIRECT("Sheet1!R" & (ROW()-1)*3+1 & "C1", FALSE)
Say you have a long oclumn of data. You want to split it into 3 columns such that, every third element goes into each column. for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula
Say you have a long oclumn of data. You want to split it into 3 columns such that, every third element goes into each column. for example youd data is: AAABBBCCCDDDEEEFFFGGGHHH
you want to split into 3 columns : ABCDEFGH, ABCDEFGH, ABCDEFGH. use the above formula
Subscribe to:
Posts (Atom)