HI Friends,

I copied data from several files and I need to make sure the Text I had copied in to different columns fall in the same row.

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.

I have also showed the desired answers.

Below is the link to the sample file

http://speedy.sh/wq3A6/Make-sure-row...same-line.xlsx

Thanks

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

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 look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "CompareColumns"
I colored the cells that do not match in red with CF.


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