Consolidating excel worksheets
As I previously discussed, Excel provides many useful ways to automatically compare two lists of data or information.
In our other example we compared two lists of four digit account values; for this example we’ll compare two lists of names.
You and a friend are throwing an epic party and have each maintained separate guest lists to track who’s coming.
After a few weeks you decide to compare both lists to make sure everyone on your friend’s list (List B) is also on your list (List A).
A name in List C means the corresponding name from List A was also found within List B.
In the screenshot above, cell D5 displays the “Moon Barrientos,” which means that name was found on both List A and B.
On the other hand, cell D12 displays which means the corresponding name from List A (in this case, “Aracely Rock”) does not exist within List B.
The best way to learn is to practice yourself, so click the link below to download the Excel 2010 workbook used to show the methods described in this post. Occasionally a client asks me to create a shared workbook in Excel, so two or more employees can work in it at the same time.It sounds good in theory, but I always try to come up with a different solution.Maybe you've had success with shared workbooks, and I'd love to hear about it in the comments.For me, the limitations far outweigh the benefits, and there's usually another way to accommodate multiple users.
After you share a workbook, many of Excel's features can't be used.