Comparing cell content

[Collcat]

HI,
I was off earlier when I asked for help with cell values.

I need help with a function that compares *cell content (tex
mostly).*
I want to compare 11 cells and if any of the cells have the sam
content, the function should indicate that 1 or more cells are th
same. Like a flag that something is wrong. If they are all differen
the function shold indicate that.

Thank You in advance

// Coolca

 

[Frank Kabel]

Hi
why not read your old thread ??

But here a repost of some formulas:
=SUMPRODUCT(--(COUNTIF($B$1:$B$10,$B$1:$B$10)>1))>0


Or some array formulas (entered with CTRL+SHIFT+ENTER)
=OR(COUNTIF($B$1:$B$10,$B$1:$B$10)>1)
=OR(FREQUENCY(B1:B10,B1:B10)>1)