cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Unique-Mark Function.

lvl107
20-Turquoise

Unique-Mark Function.

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 :

M.PNG

and the Output is :

Unique_Mark( ).PNG

Thanks in advance.

Loi.

1 ACCEPTED SOLUTION

Accepted Solutions

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.)

View solution in original post

9 REPLIES 9
MikeArmstrong
5-Regular Member
(To:lvl107)

Something like this?

Clipboard02.jpg

Mike

lvl107
20-Turquoise
(To:MikeArmstrong)

Thank you for your help, Mike. And please help me with the another. ( or refer http://communities.ptc.com/message/37393#37393 )

M_.PNGUnique_Mark( )_.PNG

Thanks once again.

Loi.

StuartBruff
23-Emerald II
(To:lvl107)

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

lvl107
20-Turquoise
(To:StuartBruff)

Thanks for your help, Stuart. Give me a time to take a look.

Loi.

MikeArmstrong
5-Regular Member
(To:StuartBruff)

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.)

MikeArmstrong
5-Regular Member
(To:StuartBruff)

Superb worksheet as usual.

I gave up in the end, tried to hard to make it work in our function.

Mike

MikeArmstrong
5-Regular Member
(To:lvl107)

Loi,

Are you trying to create a vector, which returns every row of data which occurs in M & mark non-duplicate values?

Mike

lvl107
20-Turquoise
(To:MikeArmstrong)

Oh, that's correct so. Yes, I am. Thanks a lot indeed for helping me with correction my English, Mike.

Loi.

Top Tags