Results 1 to 12 of 12

Choose a number group from a single number input.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-10-2006
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2019, Win 10
    Posts
    102

    Choose a number group from a single number input.

    I have nine Age Groups: 14-17, 18-24, etc. upto 85-94 and they occupy nine cells B1 to J1. If I input an age, say, 22 in cell A1, I would like the relevant Age Group, '18-24', displayed in A2. This would apply to any entered age from 14 to 94 which would result in the appropriate Age Group displayed.

    I probably could use loads of nested 'IFs', but is there a simpler way to achieve this?

    I've just installed Excel 2019 a few weeks ago, so I'm not upto speed with any of the latest functions - yet.

    Reagards,

    Alan
    Last edited by Zagra147; 05-03-2020 at 10:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 11-19-2019, 11:36 PM
  2. Divide a column by a number and group results in columns of that number
    By AnthonyMarx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2016, 02:06 PM
  3. How to add group number to equally divide number of rows
    By neualex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2015, 03:34 PM
  4. Replies: 6
    Last Post: 11-26-2013, 05:21 PM
  5. [SOLVED] Pulling multiple index results from a single input number
    By cwatsonSONA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 11:00 AM
  6. [SOLVED] Create serial numbers based on a single input number.
    By jmp601 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2013, 11:33 AM
  7. How Get the Invoice Number and Range the number, Group by Sales Name
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2009, 09:55 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