Vlookup

E

Ebrahim

Afternoon...

In have two spreadsheets where i have a number of duplicated information. My
objective is to eliminate this duplication that i have. I need to know is
there any way that excel will be able to pickup if there is duplication, by
running a vlookup or something? For me to actually go threw both spreadsheets
to run a cross reference will be to time consuming, is there an alternative?
Please i need assistance
 
B

bj

vlookups will work,
if the data is in column A in both sheets
insert a new column B in sheet1 and in B1 enter
=if(iserror(vlookup(A1,Sheet2!A:A,0,0),"",1)
and copy down
or if all you want to do is identify duplicates
use conditional format.
with a similar equation

countif will also work
=countif(Sheet2!A:A,A1)
 
Top