Max of unique values in cells separated by a delimiter

Hello,

I'm looking to get as a result the max count of unique values, from cells separated by a dash. I am attaching an example where you can see what I mean. The data I will be analyzing are of similar nature to the data in the thread I started a while ago today here:

http://www.excelforum.com/excel-prog...separator.html


Again a udf function would be the most flexible solution though I do appreciate any help.


Thank you

=CountMax(C6:E6,"-")

Please Login or Register  to view this content.

Hi

I created a UDF to do just this a few years ago.

It used "," and "/" as delimiters. The first two rows tell the function what to do if the target cell is empty or has "-" in it.

I will dig it out for you.

Please Login or Register  to view this content.

Hi jindon and mehmetcik,

Both macros work great! Exactly what I was looking for to achieve. Thank you very much for the replies! I was wondering if you could also help me with an additional variation with any of your macros.

Is it possible to receive as a result the max count of unique values between all the cells? I spent some time trying to edit your solutions but haven't succeeded.

Thank you both for the help!

Please Login or Register  to view this content.

Hi jindon,

Exactly what I was looking for.

Thank you very much for all assistance in my threads!

Hi jindon,

Sorry to be bothering you again, I was just wondering if you could have a look at the macros you've helped me with in post #2 and #5. They both take a long time to finish calculating, similar to the other thread I was having trouble with. Would it be possible to have a look if the calculation time can be minimized?

Thank you

Hello jindon,

I am trying to edit your macro in your post #2, to receive the minimum instead of the maximum count. I edited

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but I get only 0 as the result. Could you please have a look and let me know where I am going wrong?

Thank you very much

Please Login or Register  to view this content.

Thank you very much jindon, worked like a charm!