Dear All,
I have a worksheet with these formulas on Cells A1, A2, A3,A4
="*"&B2
=5
="*"&B3
=6
The problem is that I need to copy these two formulas trough a big numbers of rows, and I was hoping excel could find a pattern here, but as I drag these cells down, these formulas are copied like this
="*"&B6
=5
="*"&B7
=6
This isn't what I was hoping but a sequential order of the first formula like this
="*"&B4
=5
="*"&B5
=6
Is there a way to fix this? I need this to copy this for more than 250 rows.
Try this:
A1: ="*"&INDEX(B:B, FLOOR(ROW()/2,1)+1)
A2: =5
A3: ="*"&INDEX(B:B, FLOOR(ROW()/2,1)+1)
A4: =6
Now copy down.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeaucaire,
This is the first time I'm reading about the Floor function, but it works, thanks a lot
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks