+ Reply to Thread
Results 1 to 3 of 3

Return Unique Values in List Using INDIRECT, MATCH and INDEX?

  1. #1
    Registered User
    Join Date
    11-01-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Return Unique Values in List Using INDIRECT, MATCH and INDEX?

    The more I look at the data, the more it seems that a better depiction of the data would utilize:

    1) Return only unique values of Day of Week as a List (Found in Column B on "Nerves_Data")
    2) That will then return the Game Type with the corresponding 5 Weeks Out to 5 Weeks After Data
    3) This way I can graph the day of week impact on particular game types by just selecting Day of Week.


    Please let me know if this is at all possible! Thank you in advance.
    Attached Files Attached Files

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

    Re: Return Unique Values in List Using INDIRECT, MATCH and INDEX?

    This site shows how you can extract a unique list dependent on criteria in another column:

    http://www.get-digital-help.com/2009...eets-criteria/

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    11-01-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Return Unique Values in List Using INDIRECT, MATCH and INDEX?

    Quote Originally Posted by Pete_UK View Post
    This site shows how you can extract a unique list dependent on criteria in another column:

    http://www.get-digital-help.com/2009...eets-criteria/

    Hope this helps.

    Pete
    Thank you Pete, but not exactly what I'm looking for - I hope to just extract 11 columns of data (see below) that meet the unique condition (for example the number "2" in the matrix below, but won't display "2" more than once), and would return both the subsequent "a" and "b" in column B, as well as the data located from columns C through M.

    A B C ---> M (Extract this Data)
    1 a
    2 a
    2 b

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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