This works perfectly - sorry, I now see how I could have just made the column
to row adjustment myself.

I confess, I don't really understand the formula, but I guess that doesn't
matter - thanks very much for providing a solution.

Daniel


"Ron Coderre" wrote:

Um...OK..You want this:
E1: =SUMPRODUCT((A1:D1<"")/COUNTIF(A1:D1,A1:D1&""))


Does that help?

***********
Regards,
Ron


"Daniel Bonallack" wrote:

Hi Ron

Thanks for offering a solution, but I'm not sure how to apply it. Maybe my
example wasn't clear, but I wasn't sure why you have A1:A10 - I'm trying to
test across the row A1:D1, then copy that formula down to 12,000 rows.

Hope that clarifies.
Daniel


"Ron Coderre" wrote:

Try a variation of this:
E1: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
That formula counts the number of non-blank, unique items.

Does that help?

***********
Regards,
Ron


"Daniel Bonallack" wrote:

I have a text value in cells A1:D1. Let's say that the values read across
the row:
A1 = "Duck", B1 = "Duck", C1 = "Cat", D1 = "Duck"

I want a formula in cell E1 that will return "No" in this case, meaning that
the items are not all same.

The bit that makes it too hard for me is that there may be blanks, and the
blanks should not be counted. So:
A1 = "Duck", B1 = "", C1 = "Duck", D1="Duck" should be a "Yes" in column E.

Thanks very much for any help.
Daniel