+ Reply to Thread
Results 1 to 6 of 6

(URGENT) Fill cells with numbers in interval

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    35

    (URGENT) Fill cells with numbers in interval

    Hi guys, I need a bit of help here. It it a bit of an emergency, too.
    I have this:
    \1

    I want the data underneath the numbers to be filled with the values in that interval, like below:
    \1

    Any help on this is greatly appreciated!
    Attached Files Attached Files
    Last edited by JonSnow; 08-04-2013 at 07:58 AM. Reason: Added the xls file

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: (URGENT) Fill cells with numbers in interval

    See for better and quicker help, this link.

    http://www.excelforum.com/the-water-...-question.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: (URGENT) Fill cells with numbers in interval

    Quote Originally Posted by oeldere View Post
    See for better and quicker help, this link.

    http://www.excelforum.com/the-water-...-question.html
    Thanks for the advice. In case it might help, I've attached the file to the original post.

  4. #4
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: (URGENT) Fill cells with numbers in interval

    See if the attached kind of approach works.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: (URGENT) Fill cells with numbers in interval

    Duplicate - due to Forum glitch
    Last edited by elayaz; 08-04-2013 at 10:56 AM.

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: (URGENT) Fill cells with numbers in interval

    I don't know if this is what you want or not. Your profile says Office 2007 but the file is older than that so I converted it.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: (URGENT) Fill cells with numbers in interval

    See the attached file.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-01-2013
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: (URGENT) Fill cells with numbers in interval

    Thanks a lot oelder, newdoverman and elayaz! Fantastic quick solution!

+ 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. [SOLVED] Fill column by comparing numbers in different cells
    By Jokerski in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-17-2012, 03:36 PM
  2. Copy and fill cells with existing numbers
    By Vestlink in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2012, 08:21 AM
  3. [SOLVED] random numbers to fill a certain amount cells in a row
    By bunjijumper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2010, 08:15 AM
  4. fill numbers from 2 cells in a row
    By d502 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2010, 07:01 PM
  5. [SOLVED] Counting Numbers in an Interval
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM

Tags for this Thread

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