+ Reply to Thread
Results 1 to 9 of 9

extrect unique data

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    toronto
    MS-Off Ver
    Excel 2010
    Posts
    9

    extrect unique data

    Hi there,

    Anyone knows what's wrong with the fomulars in column H and column I in the attached file? it is supposed to extrect an unique list.

    Thanks a lot.

    Zhang.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: extrect unique data

    Welcome to the forum Zhang.

    Instead of trying to locate the error in your formula, instead, if you can post a sample how you want the output to be, we can help you.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: extrect unique data

    May be this.......

    Please Login or Register  to view this content.
    Edit: Forgot to mention that the formula requires confirmation with Ctrl + Shift + Enter instead of just Enter.
    Last edited by sktneer; 05-05-2014 at 11:02 PM.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: extrect unique data

    Try this one

    =IFERROR(INDEX($F$1:$F$9,SMALL(IF(FREQUENCY(MATCH($F$1:$F$9,F$1:F$9,0),MATCH($F$1:$F$9,$F$1:$F$9,0)),ROW(F$1:F$9)),ROWS(H$1:H1))),"")

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: extrect unique data

    Quote Originally Posted by sktneer View Post
    May be this.......

    Please Login or Register  to view this content.
    Note: sktneer's formula needs to used as an Array formula [which can be confirmed by pressing Ctrl + Shift + Enter].

  6. #6
    Registered User
    Join Date
    05-05-2014
    Location
    toronto
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: extrect unique data

    Sktneer, Ctrl + Shift + Enter works.

    Thanks.

  7. #7
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: extrect unique data

    Glad to help you. Thanks for the feedback.
    Since you are new to the forum so just to tell you that, if that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

  8. #8
    Registered User
    Join Date
    05-05-2014
    Location
    toronto
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: extrect unique data

    Thanks Sktneer. I have added reputation to all you guys.

  9. #9
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: extrect unique data

    Thank you for the feedback

+ 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. Replies: 8
    Last Post: 11-25-2013, 10:26 PM
  2. Performing a mathematical function on data based on data ID and unique values
    By manderax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2013, 04:52 PM
  3. allocate only unique data to multiple sheets from the main data sheet
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2013, 05:00 AM
  4. Replies: 4
    Last Post: 01-16-2013, 10:06 PM
  5. Replies: 0
    Last Post: 03-08-2012, 12:18 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