Compare-text in different columns fall in same row

[Ecel Dumbo]

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.

Attached is the sample file

Thanks

 

[David Evans]

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.

Attached is the sample file

Thanks

Here's a formula that will do it for you - doesn't agree with your results in all cases, but I think it might be OK ... - Your columns get out of sync around Row 33 it appears from a cursory review ..

 

[Ecel Dumbo]

Thanks David.