| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two databases, only display info if NOT in each list
i have two worksheets showing people's info (DB1 & DB2):
A B C D E F G 1 First Last Address 1 Address 2 City State Zip 2 3 on the third worksheet (DBmail), i only want to display mailing addresses if the contact is NOT listed in BOTH DB1 & DB2. So if sally's info is on DB1 and not on DB2, show her info. if Sally is on both lists, do not show her info. Let me know if you need any further clarification. Any help is greatly appreciated! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Col 1 & 2 to display info in rows | Excel Discussion (Misc queries) | |||
| Can I enter info in Excel and have it display as an '*'? | Excel Discussion (Misc queries) | |||
| Using Drop Downs Or Combo Boxes to Look up and display Info | Excel Discussion (Misc queries) | |||
| How do I create an entry sheet that feeds info to other databases | Excel Discussion (Misc queries) | |||
| How do I list info from one worksheet to another..... | Excel Discussion (Misc queries) | |||
Threaded Mode
