Matching

L

LC in Boston

Am trying to figure the most efficient way to compare two spreadsheets that
will have customer/account information -- trying to ID duplicate names
between the two sheets. Looked on Help and am still not sure if conditional
formatting is the way to go?
 
B

Bob Phillips

CF is good.

If the data is on separate worksheets, you will need to create defined names
for the ranges and use these.

So, assuming the named range for Sheet 2 is s2Keys, the formula to match
would be like

=ISNUMBER(MATCH(A2,s2Keys,0))

and format the cells.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

bj

conditional formating can not be used between sheets at least in 2003 Excel.
if you are looking names which are exactly alike
adding a helper column and using =countif(Sheet2!A:A),A1) will tell you if
there is a duplicate to what is in A1 in Sheet 2 Column A
 
Top