| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find duplicate data in two tables,then listing it?
I also have a little Excel file that will run a query against two
single-column lists in another workbook and return the unique entries in each list that are NOT in the other list. If you post your email address I'll send it to you "Doeu" wrote: Urgent work! I have two excel membership database, Club A & Club B. I need to find out all the members who join Club A & B, and Club A members who haven't join Club B. I will need to check it by tracing the IC(unique: combine characters & numbers) Anyone can advise on this? As for as I know, SQL able to solve this. Is it possible to solve it in Excel and Access? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
| Preventing duplicate data | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
