| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating a reconciling list of items not matched between two files
I am trying to reconcile 2 xl files and need to generate two lists of items
not included on the other worksheet. ie. On file 1 not on file 2, and, on file 2 not on file 1. Both files have two colums. Column A is a 6 digit number and column B is a dollar value. Both files have in excess of 10,000 rows. List of reconciling items needs to show data from both columns. Both files can be merged to the same worksheet if this simplifies the solution. I have used VLOOKUP and filtered by #N/A and then cut and pasted visible cells to create my list but was hoping for a simpler solution. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a filtered list | Excel Discussion (Misc queries) | |||
| how do i create a drop down list of items from a different file | Excel Worksheet Functions | |||
| How do I delete items in one list from another list? | Excel Discussion (Misc queries) | |||
| Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Threaded Mode
