Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find duplicate data in two tables,then listing it?
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! |
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 |