LinkBack URL
About LinkBacks
Hi all,
From a data like 1,2,3 till 20 in range A1:T1
Can I split the rows like following:
1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20
Regards,
Kisan Vikas
Hi all,
From a data like 1,2,3 till 20 in range A1:T1
Can I split the rows like following:
1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20
Regards,
Kisan Vikas
Maybe like this. Drag across and down to give the desired size.
=INDEX($A$1:$T$1,ROWS($D$4:$D4)+(COLUMNS($D$4:D$4)-1)*5)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Maybe something like this? Pls see the file attach
best regards
Azumi - better than my effort, but the 4's need to be 5's, as in:
IFERROR(IF(ROWS($A$1:A1)<=5,INDEX($A$1:$T$1,ROWS($A$1:A1)+(COLUMNS($A$1:A1)-1)*5),""),"")
Last edited by Glenn Kennedy; 04-25-2015 at 05:35 AM.
=if(row(a1)>5,"",iferror(index($a$1:$t$1,row(a1)+column(a1)*5-5),""))
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hey Azumi,Originally Posted by azumi
The formula you gave me require some modification.
Here you areFormula:
Please Login or Register to view this content.
Regards,
Kisan Vikas
Thanks Glenn, Azumi & Siva
Your formulas are working perfectly fine.
Regards,
Kisan Vikas
Thanks for the feedback...........
Thanks for the feedback, but Azumi's and nflsales' are better!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks