Hi all,
I am trying to create a number pattern. 24 rows of "1", followed by 24 rows of "2", followed by 24 rows of "3", etc. up through "365". Any ideas how to do this? Autofill is not working for this pattern. Thank you!
Hi all,
I am trying to create a number pattern. 24 rows of "1", followed by 24 rows of "2", followed by 24 rows of "3", etc. up through "365". Any ideas how to do this? Autofill is not working for this pattern. Thank you!
perhaps try this... =INT((ROWS(A$1:A1)-1)/24)+1 dragged down
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Worked perfectly, thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks