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

Unique-Mark Function.

  • December 17, 2010
  • 1 reply
  • 5589 views

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.

Best answer by StuartBruff

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

1 reply

M
MikeArmstrong1-Visitor
1-Visitor
December 18, 2010

Something like this?

Clipboard02.jpg

Mike

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

S
StuartBruff23-Emerald V
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

Terms & ConditionsAccessibility statement