I am having problem with combining two long excel files which has same
similear cell such as name, title, publish date and I want to get ride off
any cell or cells having the same. I should only have one name, title,
publisher.

one of the ways to do it would be to copy the data from the second sheet to
the bottom of the first sheet.

Make sure the columns are aligned for the different variables.

I assume that you could have the same name with different titiles so that
just duplicates of any one column would not be the way to look

If say there were five columns of information (A: E)
if there is a preference as to the sheet to retain data from (Say the first)
in F1 enter
=if(and(countif($A$1:A1,1)1,countif($B$1:B1,1)1, countif($C$1:C1,1)1,countif($D$1:D1,1)1),1,0)
And copy down to the bottom of the data.
use auto filter and select the 1s in column F
Delete the rows with the 1s



"Nav" wrote:

I am having problem with combining two long excel files which has same
similear cell such as name, title, publish date and I want to get ride off
any cell or cells having the same. I should only have one name, title,
publisher.