Exact check for multiple more than two cells

**kbka** · 08-16-2012, 05:28 AM

Hi,

I need to check if multiple cells are identical. The Exact function works for two cells, however, I have about 10 cells that must match.

Basically something like
=exact(A1;B1;...;M1)

is this in someway possible?

I know that i could check in pairs and then use if functions, but thats somewhat heavy.

any help is much appreciated,
kbka

**Fotis1991** · 08-16-2012, 05:43 AM

Hi

Also heavy...?

=AND(EXACT(A1,B1),EXACT(A1,C1),EXACT(A1,D1),EXACT(A1,E1))................

**Ace_XL** · 08-16-2012, 05:49 AM

How about..

=IF(COUNTIF(A1:J1,A1)=COUNTA(A1:J1),TRUE)

---------- Post added at 01:49 PM ---------- Previous post was at 01:46 PM ----------

Considering the possibility of blank cells..

=IF(COUNTIF(A1:J1,A1)=(COUNTA(A1:J1)+COUNTBLANK(A1:J1)),TRUE)