Originally Posted by
Sam Capricci
For post #11 I really don't follow you. If you could upload a sample workbook with what you have AND what you expect that would be helpful.
it sounds like A1 through A640 will all be 1 but then you talk about the first 8 as 1, the next 8 will be 2, etc. Where would these be located?
This formula will give you 8 1s, then 8 2s etc anywhere you put it...
=ROUNDUP(ROWS($A$1:A1)/8,0)
But if that isn't what you want, then, as I noted, a workbook with what you have AND what you expect would be very helpful.
Bookmarks