Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching
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) "LC in Boston" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching
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 "LC in Boston" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching | Excel Discussion (Misc queries) | |||
Need help matching... | Excel Worksheet Functions | |||
Matching | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Matching | Excel Worksheet Functions |