Cable Forum - View Single Post - Yet another Excel formula question for the experts!!

TheNorm · 23-01-2007, 13:53

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.

23-01-2007, 13:53	#2
TheNorm Inactive Join Date: Jun 2006 Location: Cambridge Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died). Posts: 4,349	Re: Yet another Excel formula question for the experts!! 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.