Hi all,
Trying to figure out a way to continue a sequence without having to do it all manualy.
I have a column with data and then a column with some static text to surround the data.
Please see example attached as i'm not sure how to explain.
Any questions please ask!!
Thanks in advance,
Chris
As long as you start at the 2nd row and skip 2 rows before having a new entry, then try:
=INDEX($A$1:$A$1000,3*(ROWS($A$1:A1)-1)+2)
copied down...
Note: Adjust the bottom range ($A$1000) to whatever your bottom of the range is in order to include all possible data.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi,
This formula in column A will continue the pattern you've started.
=IF((ROW()+1)/3=INT((ROW()+1)/3),INDEX($E$1:$E$50,(ROW()+1)/3),"</test>")
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
I may have misinterpreted your needs... I think Sweep's solution leans towards what you probably really want...
Mine extracts the addresses from column A and places them one row after another....which is, I think, the opposite of what you want....?
sweep -
not quite sure how this works - but it does. Perfectly!
Thanks a lot!
NBVC -
Thank you for posting, your way was equally helpful as this gives me a demo on how to extract the information if i recieve it in that format which i most certainly will come across shortly!
excelforum to the rescue as usual!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks