Help with formula


J

Josh W

Please help create a formula/shortcut for the following:
A1=1
A2=1
A3=1
A4=2
A5=2
A6=2
A7=3
A8=3
A9=3
And so on, each number in increment of three, all the way down. Thanks.
Excel 2003
 
Ad

Advertisements

J

Josh W

Rick, for some reason the formula you gave me merges two cells and only
starts at no. 3.
 
R

Rick Rothstein

I'm not sure what you mean by "merges two cells". What cell did you put the
formula in to start with, A1 as your example showed or some other cell on
some other row? Give this modification to the formula I posted a try and see
if it works for you...

=1+INT((ROW(A1)-1)/3)
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top