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

microsoft excel

ResolvedVersion 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:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.