LinkBack URL
About LinkBacks
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
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
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
Life's a spreadsheet, Excel!
Say thanks, Click *
Use this for columns:
Formula:
Please Login or Register to view this content.
And similliar for rows:
Please Login or Register to view this content.
Never use Merged Cells in Excel
ok so if the #'s were 300, 400, and 500 would it still work or does that need a different formula?
Did you try the suggestion?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
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
Just multiply the result by 100000Originally Posted by TwistedFaith
=INT(ROW(A3)/3)*100000
I did that and it starts at 100000
I need it to start at 300000
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
That last variation work. Thanks for your guys help
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.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks