+ Reply to Thread
Results 1 to 8 of 8

Auto fill decimal sequence using custom fill or formula

  1. #1
    Registered User
    Join Date
    11-10-2006
    Location
    New York
    Posts
    7

    Question Auto fill decimal sequence using custom fill or formula

    Hi,

    I am trying to use auto fill to do a sequence like this instead of having to type many rows of something that is very repetitious:

    ZCT150 5.0
    ZCT150 5.5
    ZCT150 6.0
    ZCT150 6.5
    ZCT150 7.0
    ZCT150 7.5

    ETC.

    I tried a custom fill, but that does not do what I expected. It just does the same as the auto fill.

    I'm thinking maybe a formula will do it, but I'm not sure how to build such a formula.

    Any help is greatly appreciated!

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,543

    Re: Auto fill decimal sequence using custom fill or formula

    Hi,

    Will the sequence always begin with "ZCT150" followed by a space followed by a decimal which is 0.5 greater than that in the previous entry?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    11-10-2006
    Location
    New York
    Posts
    7

    Re: Auto fill decimal sequence using custom fill or formula

    Sorry, I did mess up! The ZCT150 will change also.

    ZCT150 5.0
    ZCT155 5.5
    ZCT160 6.0
    ZCT165 6.5
    ZCT170 7.0
    ZCT175 7.5

  4. #4
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,543

    Re: Auto fill decimal sequence using custom fill or formula

    Perhaps:

    ="ZCT"&145+5*ROWS($1:1)&TEXT(4.5+ROWS($1:1)/2," 0.0")

    and copy down.

    Regards

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,921

    Re: Auto fill decimal sequence using custom fill or formula

    ="ZCT150 "&TEXT(4.5+ROWS($1:1)/2,"0.0")

    Or try this
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Auto fill decimal sequence using custom fill or formula

    I have used with expandable range.

    Please try this as well.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  7. #7
    Registered User
    Join Date
    11-10-2006
    Location
    New York
    Posts
    7

    Re: Auto fill decimal sequence using custom fill or formula

    Quote Originally Posted by XOR LX View Post
    Perhaps:

    ="ZCT"&145+5*ROWS($1:1)&TEXT(4.5+ROWS($1:1)/2," 0.0")

    and copy down.

    Regards
    Thank you so much! I used this one first and it worked great. We are just having a formatting problem with the Excel spreadsheet that I need to address. It works fine in a general format, but the spreadsheet that the person I am helping is using is a text format. I have had this problem before and should be able to work it out.

    Thanks again!

  8. #8
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,543

    Re: Auto fill decimal sequence using custom fill or formula

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to create a custom auto fill sequence
    By lix333 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-06-2012, 09:40 PM
  2. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  3. Auto fill sequence
    By trakai in forum Excel General
    Replies: 13
    Last Post: 09-12-2007, 12:24 PM
  4. Replies: 1
    Last Post: 07-13-2007, 10:59 AM
  5. auto fill sequence...
    By tiaj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2006, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1