Skip to main content
20-Turquoise
December 17, 2010
Solved

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.

23-Emerald V
December 20, 2010

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

9 replies

1-Visitor
December 18, 2010

Something like this?

Clipboard02.jpg

Mike

Translate
lvl10720-TurquoiseAuthor
20-Turquoise
December 18, 2010

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.

Translate
23-Emerald V
December 18, 2010

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

Translate