Well, you could lose the AND function. It's not doing anything.

Other than that, we need to know what else you want to do with the formula.
Even if it takes "forever" to input, once it's in, what's the problem?

Regards,
Fred.

"Kevin" wrote in message
...
I need to determine if any of the following groups of cells match each
other.
For instance, H8&H9 match H11&H12, or H14&H15 match H8&H9, or H11&H12
match
H14&h15, etc...these cells contain a name and text that I don't want
repeated
in the same column. If so, an error appears. I'm using dropdowns for all
the
cells if that matters. The following formula is used for one cell under
conditional formatting and is the closest I can come to a solution, but
this
will take forever to input...all ideas appreciated.
=AND(OR(H8&H9=H11&H12,H8&H9=H14&H15,H8&H9=H17&H18, H8&H9=H20&H21,H8&H9=H23&H24,H8&H9=H26&H27,H8&H9=H2 9&H30))