Hi,

Am Mon, 1 Jun 2015 00:38:45 +0100 schrieb Excel Dumbo:

Using Column A as the base, I need tocompare columns C, E,G,I,L,N,P.
Making sure all Text in the these columns fall in the same row as Column
A. Once checked i'll later be deleting C, E,G,I,L,N,P.

please check your result column.
You could use in S2:
=COUNTIF(C2:P2,A2)=7
That gives you TRUE or FALSE
From row 33 downwards all results are FALSE


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional