Quote:
Originally Posted by TheNorm
Interesting. Another way of looking at this is to say that the content of every row should be unique. Agreed?
Have a look at Method 2: http://www.mrexcel.com/tip138.shtml
In your case, you would need to add E, which concatenated cells A to D to make a long string. You would then test the uniqueness of it. |
Thanks TheNorm
Does not do quite what I want as the contents of every row would not need to be unique. All of the one's should be unique, all of the two's unique, etc.
I could look at this by filtering. The problem is, that the ones, twos etc, will amount to thousands, and that's a lot of filtering!
Many thanks
Abs