Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I compare worksheets in the same workbook?
I have two storerooms in the same workbook (separate worksheets) and need to
find shared items that have different item numbers (the column names in each sheet match.) I can use the FIND function to locate individual shared items in both storerooms, but with over 4,000 items, I'm hoping for a faster method. |
#2
|
|||
|
|||
Malcolm M wrote:
|| I have two storerooms in the same workbook (separate worksheets) and || need to find shared items that have different item numbers (the || column names in each sheet match.) I can use the FIND function to || locate individual shared items in both storerooms, but with over || 4,000 items, I'm hoping for a faster method. Have a look he http://www.cpearson.com/excel/duplic...tingDuplicates -- Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk |
#3
|
|||
|
|||
Thank you. I think it is just what I need. I'm not exactly a whiz at Excel,
but your suggestion looks self-explanatory. "Gordon" wrote: Malcolm M wrote: || I have two storerooms in the same workbook (separate worksheets) and || need to find shared items that have different item numbers (the || column names in each sheet match.) I can use the FIND function to || locate individual shared items in both storerooms, but with over || 4,000 items, I'm hoping for a faster method. Have a look he http://www.cpearson.com/excel/duplic...tingDuplicates -- Gordon Burgess-Parker Interim Systems and Management Accounting www.gbpcomputing.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
How do i group worksheets inside a workbook into subgroups? | Excel Worksheet Functions | |||
Viewing Worksheets withing One Workbook | New Users to Excel | |||
Count the number of worksheets in a workbook | Excel Discussion (Misc queries) |