I am sure that there is a smarter approach then this brute one:

```
=IF(COUNTIFS(O40<>P40;O40<>Q40;O40<>R40;O40<>S40;O40<>T40;O40<>U40;
p40<>o40;p40<>Q40;p40<>R40;p40<>S40;p40<>T40;p40<>U40;
q40<>P40;q40<>o40;q40<>R40;q40<>S40;q40<>T40;q40<>U40;
r40<>P40;r40<>Q40;r40<>o40;r40<>S40;r40<>T40;r40<>U40;
s40<>P40;s40<>Q40;s40<>R40;s40<>o40;s40<>T40;s40<>U40;
t40<>P40;t40<>Q40;t40<>R40;t40<>S40;t40<>o40;t40<>U40;
u40<>P40;u40<>Q40;u40<>R40;u40<>S40;u40<>T40;u40<>o40);1;2)
```

I tried something like this but its not working as that above:

```
=IF(COUNTIF({O40;P40;Q40;R40;S40;T40;U40}<>{O40;P40;Q40;R40;S40;T40;U40};{O40;P40;Q40;R40;S40;T40;U40}<>{O40;P40;Q40;R40;S40;T40;U40});1;2)
```

can someone briefly teache me? thx

**EDIT:**

explanatory: on row 40 I have 7 cells with some mixed values (numbers, laters). what I'm trying to do here is to check every cell from those 7 with every cell of those 7. so if there is no match between them then value 1 is displayed and if there is a match then value 2 displays. embeding image with colors:

=IF(COUNTIF(O40<>P40;O40<>P40 ; O40<>Q40;O40<>Q40......? well as I explained in the post: all I wana is to compare those 7 cells with each others and find out if there is not any "duplicates" – gamer0 May 13 '18 at 21:44