LinkBack URL
About LinkBacks
Hi
I have an array of data, say C2:C100, and I want to be able to drag a cell down with =c2 in it, and then when it gets to c100, start over at c2 again. Any ideas?
Many thanks
Hi
I have an array of data, say C2:C100, and I want to be able to drag a cell down with =c2 in it, and then when it gets to c100, start over at c2 again. Any ideas?
Many thanks
c2 to c100 is 99 rows
so
=INDEX($C$2:$C$100,IF(MOD(ROW(A1),99)=0,99,MOD(ROW(a1),99)))
will =c2.....c100 then =c2...c100 again
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you, works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks