Increasing cells by 1/3 with autofil

[TwistedFaith]

hi guys my mind is drawing a blank. I'm trying to find a formula that increase a cell by 1/3 that will work with auto fill.

For Example if auto-filling a column:
3
3
3
4
4
4
5
5
5

Or if auto-filling a row:
3 3 3 4 4 4 5 5 5

[Ace_XL]

Put first cell in A1

In A2
=A1+(COUNTIF($A$1:A1,A1)=3)
Copy down

or
In B1
=A1+(COUNTIF($A$1:A1,A1)=3)
Copy across

[zbor]

Use this for columns:

Please Login or Register  to view this content.

And similliar for rows:

Please Login or Register  to view this content.

[TwistedFaith]

ok so if the #'s were 300, 400, and 500 would it still work or does that need a different formula?

[FDibbins]

Did you try the suggestion?

[TwistedFaith]

Yea I tried both suggestions. The one's from Ace_XL works but if the #'s are higher then 9 the 3rd # ends with a 1 so if I started with 300 the 3rd 300 will say 301 then go to 400. The suggestion's from zbor work great but I'm just trying to figure out how to get it to start at 300000 and go up every 3rd # from that.
300000
300000
300000
400000
400000
400000
500000
500000
500000

[Jonmo1]

The suggestion's from zbor work great but I'm just trying to figure out how to get it to start at 300000 and go up every 3rd # from that.

Just multiply the result by 100000

=INT(ROW(A3)/3)*100000

[TwistedFaith]

I did that and it starts at 100000
I need it to start at 300000

[Jonmo1]

Oh, ok it starts at 1, but you want it to start at 3

=INT(ROW(A9)/3)*100000
or
=(INT(ROW(A3)/3)+2)*100000


Although, I actualy prefer rowS over row

Try this variation.
=(INT((ROWS($1:1)-1)/3)+3)*100000

[TwistedFaith]

That last variation work. Thanks for your guys help

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Jonmo1]

You're welcome