9 Replies Latest reply: Dec 20, 2010 1:31 PM by MikeArmstrong

# 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 :

and the Output is :

Loi.

• ###### Re: Unique-Mark Function.

Something like this?

Mike

• ###### Re: Unique-Mark Function.

Thanks once again.

Loi.

• ###### Re: Unique-Mark Function.

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

• ###### Re: Unique-Mark Function.

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

Loi.

• ###### Re: Unique-Mark Function.

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

• ###### Re: Unique-Mark Function.

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

• ###### Re: Unique-Mark Function.

Superb worksheet as usual.

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

Mike

• ###### Re: Unique-Mark Function.

Loi,

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

Mike

• ###### Re: Unique-Mark Function.

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

Loi.