Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
My customer wants an "Unmatched Query" done in Excel. He doesn't want to use MS Access to create this. Is there a Macro or inbuilt Excel function that would let us do this? Scenario: In a single workbook, there are 3 spreadsheets - spr1, spr2, and spr3. spr1 and spr2 have just one columns of names in them. My customer wants to find all the names in spr2 that does not match with the names in spr1 and transfer the result in spr3. Is this possible? Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Unmatched Records | New Users to Excel | |||
Find unmatched rows between 2 worksheets | Excel Discussion (Misc queries) | |||
listing unmatched items! | Excel Worksheet Functions | |||
flagging unmatched items!!! | Excel Worksheet Functions | |||
finding unmatched data | Excel Worksheet Functions |