+ Reply to Thread
Results 1 to 5 of 5

Need to display Unique Values in a list and return them

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need to display Unique Values in a list and return them

    I have the following table:

    Class Name Result 1 Result 2 Result 3 Result 4 Result 5
    D David 3703 3714 3769 3773
    D John 3714 3719
    D Edward 3684 3741 3749 3763 4943
    D Stuart 3650 3660 3718
    D Jill 3633 3688 3695 3769
    D Jean 3654 3690 3702 3707 3757
    D Harry 3646 3651 3658 3740
    D Ross 3653 3663 3677 3700
    D Phil 3648 3654 3682 3687 3764
    D Clayton 3665 3674 3663
    D Neil 3635 3649 3653 3683 3663
    D Craig 3620 3651 3685 3698 4927
    D Yang 3693 3705 3724 3736 4804
    D Martin 3617 3620 3668 3687 3620
    D Ian 3680 3700 3769 3773
    D Andy 3714 3632 3636 3771


    Basically I want to type in a Result e.g 3663 and I would like to return a list of all the occurances of this result and who got the result

    So in this case 3663 would return

    Ross
    Clayton
    Neil

    As these are the only three entries with 3663
    Attached Files Attached Files
    Last edited by citibond; 04-11-2012 at 11:37 AM. Reason: Wrong file

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Need to display Unique Values in a list and return them

    One simple way would be to use a helper column, say Column J. (This can be hidden.)
    Then in say K1 put your desired number.
    In J2
    Please Login or Register  to view this content.
    In K2
    Please Login or Register  to view this content.
    Drag fill both Down as required.
    Attached Files Attached Files
    Last edited by Marcol; 04-11-2012 at 02:47 PM. Reason: Forgot attachment.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Need to display Unique Values in a list and return them

    deleted... see post #5 below.
    Last edited by icestationzbra; 04-26-2012 at 12:37 AM.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Need to display Unique Values in a list and return them

    @ icestationzbra

    See this page Please read and adhere to these simple rules!
    Rule 2
    Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

  5. #5
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Need to display Unique Values in a list and return them

    attached is another approach - no helper column required...
    Attached Files Attached Files
    Last edited by icestationzbra; 04-26-2012 at 12:40 AM. Reason: correct file attached...
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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