Results 1 to 3 of 3

Thread: Display set range of numbers between an upper and lower limit
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2018
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Display set range of numbers between an upper and lower limit

    I've got a sheet that works out the lower and upper limits of parts based on certain criteria, I want to display the parts available between and including these numbers.
    The 13 available numbers are based on the strength of the part, so 35, 40, 63, 65, 80, 85, 100, 105 etc.
    If the cells show 63 min, and 85 max, I want a cell to show 63, 65, 80 and 85 as the available options.
    It seemed easier before I started to do it,,,
    Help appreciated, cheers,

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,154
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Display set range of numbers between an upper and lower limit

    Do you have a list of the 13 available parts?
    If posting code please use code tags.

  3. #3
    New Member
    Join Date
    Jan 2018
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Display set range of numbers between an upper and lower limit

    35, 40, 63, 65, 80, 85, 100, 105, 125, 180, 185, 200, 250 are the part numbers,

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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