Compare the each cell of one column to another column cell

[ajaykr333]

Dear Friends
What shall i do to two compare each cell on a column with each cell of another column. Also the cell has same data then i want to delete the data from one column.
Thanks
Ajay

 

[KenWright]

Can you clarify that please.

I can take "compare each cell on a column with each cell of another column" to mean one of two things:-

1) Compare A1 to B1, then A2 to B2, then A3 to B3 etc down to A100 to B100, and effectively have 100 TRUE/FALSE answers based on those comparisons

2) Compare A1 to each cell in B1:B100, then A2 to each cell in B1:B100, then A3 to each cell in B1:B100, right down to A100 to each cell in B1:B100, anda fefectively have 10,000 TRUE/FALSE answers based on those comparisons

Are you simply looking to combine the two lists and remove any duplicates?

Regards
Ken.............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[ajaykr333]

Thanks Ken.. for your reply.As you have written two option , what i want to ask is

Compare A1 to each cell in B1:B100, then A2 to each cell in B1:B100, then A3 to each cell in B1:B100, right down to A100 to each cell in B1:B100, simultaneously i want to delete the matched cell from one column.
So that i donot have duplicate records.

Regards......
Ajay

 

[bluedragon2]

One way is to:

In col C, put =IF(ISNA(VLOOKUP(A1,B:B,1,FALSE)),"","Duplicate&quot

This will give you the duplicates in Col A. Now:

In Col D, put
=IF(C1="Duplicate","",A1)

This will delete the duplicates in Col A. Copy/Paste Special/Values of Col D.



Blue

If I wasn't Blue, I would just be a Dragon...