Hello:
Please refer to attached file.
I have a date in row 2, on every 4th column starting in column P.
I need a formula to put this data in column F starting row 5 as shown.
Let me know if you have any questions.
Thanks.
Hello:
Please refer to attached file.
I have a date in row 2, on every 4th column starting in column P.
I need a formula to put this data in column F starting row 5 as shown.
Let me know if you have any questions.
Thanks.
This array formula will do the trick
=INDEX($P$2:$AB$2,SMALL(IF($P$2:$AB$2<>"",COLUMN($P$2:$AB$2)-COLUMN($P$2)+1),ROW(A1)))
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Try this in F5 and filled down
=INDEX($2:$2,(ROWS($2:2)-1)*4+16)
Jumped the gun on the array formula, you can use this
=OFFSET($P$2,0,(ROW(A1)-1)*4)
Hello The Cman81:
I like your OFFSET solutions, works great.
Thank you so much for great help.
Riz
Glad to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks