| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Mulitplie workbooks - known duplicate records - need to consolidat
I have 4 worksheets that need to be consolidate into one to form a master
listing, there are known duplicates between worksheets - total ~30000 records and 30 colums name hours date project x 1 10/01/2005 a x 2 11/01/2005 a y 1 12/01/2005 b I then need to compare this master to 4 other worksheets to determine in which sheet the record is located. Any easy way to do this ? Tried CONCETENATE and VLOOKUP - keeps crashing :( |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| Can I merge workbooks in Excel with fewer records in 2nd workbook? | Excel Discussion (Misc queries) | |||
| deleting duplicate records in a mail merge | Excel Discussion (Misc queries) | |||
| In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
| Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
