microsoft excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Microsoft Excel

Microsoft Excel

resolvedResolved · High Priority · Version 2007

Thanh has attended:
Excel Intermediate course

Microsoft Excel

Hi STL,

My query relates to comparing data between two separate table columns.

This is all in relation to sending out two mailing lists:
Mailing List 1 - Print
Maling List 2 - Email

Within these table lists the way the data is formatted is the same. For example, Full Name, Job Title, Company Name, Address 1, Address 2, Address 3, Post Code / Email address etc...

The data within both table lists is derived from the same source- our CRM database. Essentially we want to try and send out the two lists via print and email, ensuring that the same contacts are not targetted twice- removing duplication of contacts. Therefore, Bob Smith from Hypothetical Company Ltd is in either only the print mailing list or the emailing list- not both.

Would some type of VLook Up formula allow for this?

Thank you for your time,

Thanh

RE: Microsoft Excel

Hi Thanh, thanks for your query. You could achieve this with VLOOKUPs, with a little work, but a simpler and more visual method would be to use some conditional formatting. There's a good walkthrough on this method here:

http://spreadsheetpage.com/index.php/tip/comparing_two_lists_with_conditional_formatting/

Hope this helps,

Anthony

Fri 29 Jun 2012: Automatically marked as resolved.


 

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips


Server loaded in 0.07 secs.