+ Reply to Thread
Results 1 to 9 of 9

extract data that is not repeated within this matrix

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    extract data that is not repeated within this matrix

    Hi.

    I have an array of 3 columns.

    I need to extract data that is not repeated within this matrix
    Attached Files Attached Files
    Last edited by marreco; 11-08-2012 at 05:23 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: extract data that is not repeated within this matrix

    ? As far as I can see, there are no unique values - all of the data is repeated throughout your array - ?
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: extract data that is not repeated within this matrix

    Hi.

    I have a matrix with 3 columns, all data on it will be repeated data.

    I need to extract the data that NO repeats this matrix

  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: extract data that is not repeated within this matrix

    Is this what you need?

    With your unique values in E2 down
    In F2, Drag/Fill Down
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Try deleting any single value in A2:C8 to see the changes in Column F.
    Attached Files Attached Files
    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.

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: extract data that is not repeated within this matrix

    Hi.

    sorry it is not.

    I need to extract text that is not repeated within the matrix "A2: C8"


    The function should look at the range "A2: C8" and drag down to show me

    What unique values​​, are:
    ball
    pen
    carpet

  6. #6
    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: extract data that is not repeated within this matrix

    How about posting a workbook with your real data and showing expected result?

  7. #7
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: extract data that is not repeated within this matrix

    Ah, ok - I think I understand you now. Do you mean distinct values? If so, I pulled a speadsheet from here: http://www.get-digital-help.com/2009...umns-in-excel/, which allowed me to produce such a list.

    Hopefully this is what you want.
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: extract data that is not repeated within this matrix

    Hi.

    Perfect!!

  9. #9
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: extract data that is not repeated within this matrix

    Glad I could help, marreco, and thanks for the rep

+ 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