Dear forum,
I registered since I have a question where I just cannot figure out an intelligent way to solve my problem.
What I want is to detect if multiple cells contain the same content, and if they do identify as "x" and if they are different, then an "OK" is marked.
My solution is as follows:
I have created the following formula which shows exactly what I need, for an exemplary three adjacent cells:

=IF(D804="";"x";(IF(E804="";"x";(IF(F804="";"x";IF(D804=E804;"x";(IF(D804=F804;"x";(IF(E804=F804;"x";"OK"))))))))))

As you can see, there are three cells here (D804, E804 and F804) which are compared and depending on whether at least one repetition is present an "x" is indicated or "OK".

So far so good.

This is however a manual solution specific to three cells; what I now need is a solution for any number of cells. Is there a solution for this?
Thanks in advance!