+ Reply to Thread
Results 1 to 3 of 3

INDEX from a List in Order

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    Miami, FL
    MS-Off Ver
    Excel 2013
    Posts
    1

    INDEX from a List in Order

    Hi everyone.. I'm a professor working on an excel spreadsheet for a vocabulary review game I plan to use in my class. I'm trying to figure out how to best get this to work.

    Basically, The main game is on sheet 'A'; I have a list of 100 vocabulary words on sheet 'B'; I have 8 cells on the main game on sheet 'A' where the first 8 words from my list on sheet 'B' should be displayed. I'd like to have a button next to each of the 8 cells on sheet 'A' so that when I press it, it will replace the value of that cell with the next available word from my list that hasn't been used yet. In the past I've accomplished this but randomly choosing from the list which has often produce duplicate and repeat values. My main issue is to have excel retrieve the values in order down my list every time I press the button next to the cells on sheet 'A'.

    Anyone know of what formula or setup could accomplish this?

    Thank you in advance for any help or suggestions!

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,145

    Re: INDEX from a List in Order

    Hi and welcome

    Could be a bit a bit tricky with formulas only, but would be a doddle with VBA.

    If that's an option for you, attach your workbook so we can see it in contexts and we can help with code for it.

    BSB

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,928

    Re: INDEX from a List in Order

    You could use a Spin Button to increment or decrement your "set" number, and then use an INDEX formula to retrieve your names for each set of 8 words. Follow the instructions in the yellow banner at the top of the screen in order to attach your sample Excel workbook.

    Hope this helps.

    Pete

+ 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 do I populate an Order Sheet from a Product List using INDEX MATCH?
    By HWall97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2017, 09:47 PM
  2. Copy tabs names to index sheet in alphabetical order
    By cjharley1450 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 01:00 PM
  3. [SOLVED] Cumulative SUM of values - in a order specified by a order list 1-10
    By etaf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2015, 03:56 PM
  4. [SOLVED] INDEX Formula - Want to list names in Numerical Order
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-01-2015, 12:06 PM
  5. Replies: 0
    Last Post: 02-15-2014, 10:30 AM
  6. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  7. purchase order list & order number generator
    By podaf in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 06:02 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