Hello,
I'm looking for a formula that would repeat a number 24 times and then move on to the next number in sequential order. Any help with this would be greatly appreciated. Thank You.
Example:
1111...(24 times then) 2222...(24 times then)3333... and so on.
Last edited by artiststevens; 12-14-2010 at 08:01 PM.
Copy that formula down as far as you need.
A3: 1111 A4: =A3+IF(MOD(ROWS($3:3),24)=0,1111)
or...
Copy that formula down.A3: =REPT(CEILING(ROWS($3:3),24)/24,4)
Is that something you can work with?
Last edited by Ron Coderre; 12-14-2010 at 10:20 AM.
Thanks Ron! That's exactly what I needed!
I've been looking for this for hours!
Many Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks