Hi.
I have an array of 3 columns.
I need to 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
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.
? 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.
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
Is this what you need?
With your unique values in E2 down
In F2, Drag/Fill Down
Formula:Please Login or Register to view this content.
Try deleting any single value in A2:C8 to see the changes in Column F.
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.
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
How about posting a workbook with your real data and showing expected result?
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.
Hi.
Perfect!!
Glad I could help, marreco, and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks