Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
Hello,
I have a similar question with the "Unique Function" title, and need help. That's about "Extracting the Unique Rows and Marking to the Row Alone". The Input is :
and the Output is :
Thanks in advance.
Loi.
Solved! Go to Solution.
Mike Armstrong wrote:
That's some function. Would have thought it could be done a lot simpler. I have been racking my brain for a few hours now, but cannot seem to write a function.
Umm, yes. That was just a field-expedient TOTH fix. Here's a slightly more general lunch-time version using Tom Gutman's stable Csort plus a very basic brute force function that will just about do for small matrices but should be easier to follow. The new functions should handle any numeric or alphabetic matrix.
Stuart
(attachment changed at 1532Z as it wasn't the 'latest' saved version.)
Something like this?
Mike
Thank you for your help, Mike. And please help me with the another. ( or refer http://communities.ptc.com/message/37393#37393 )
Thanks once again.
Loi.
Something like the attached?
Needs considerable work and rethinking if you intend to use matrices with more than about 10 columns or larger numbers in the matrices.
Stuart
Thanks for your help, Stuart. Give me a time to take a look.
Loi.
Stuart,
That's some function. Would have thought it could be done a lot simpler. I have been racking my brain for a few hours now, but cannot seem to write a function.
Mike
Mike Armstrong wrote:
That's some function. Would have thought it could be done a lot simpler. I have been racking my brain for a few hours now, but cannot seem to write a function.
Umm, yes. That was just a field-expedient TOTH fix. Here's a slightly more general lunch-time version using Tom Gutman's stable Csort plus a very basic brute force function that will just about do for small matrices but should be easier to follow. The new functions should handle any numeric or alphabetic matrix.
Stuart
(attachment changed at 1532Z as it wasn't the 'latest' saved version.)
Superb worksheet as usual.
I gave up in the end, tried to hard to make it work in our function.
Mike
Loi,
Are you trying to create a vector, which returns every row of data which occurs in M & mark non-duplicate values?
Mike
Oh, that's correct so. Yes, I am. Thanks a lot indeed for helping me with correction my English, Mike.
Loi.