Comparing and formatting common fields

[Graham Inchmead]

Hi there, I wonder if someone can help me? I have 2 Excel sheets:

1. Mailing list with an address column
2. Exception mailing address column

What I need to do is take the address column on the mailing list and compare it to the exception mailing address column. If the address column is in the exception mailing list column, then I need to know - perhaps return a "true" value in a column on the mailing sheet or highlight that address in a colour. I don't mind how I get to know (if that makes sense).


Thanks,
Graham

[Pete_UK]

It would help if you attached a sample Excel workbook, so we can see what columns you are using.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

Hope this helps.

Pete

[Graham Inchmead]

Sure, no problem at all.

So, if the address on "not these address" is in column D, I need to know.


Thanks,
G

[Pete_UK]

Which column contains "not these address" ?

Pete

[Graham Inchmead]

Column A on the "not these address" sheet

[Pete_UK]

You attached a .csv file, so there is only one sheet.

Pete

[Graham Inchmead]

Oh man... Sorry about that.
Here you go.

[Pete_UK]

You could put a formula like this in V2 of the main sheet:

=IF(COUNTIF('Not these address'!$A:$A,D2),"Omit","include")

and copy it down. However, this is looking for an exact match between the addresses, and it doesn't find any in this case. I suspect you might need something more sophisticated than this, to ensure that you pick up matching addresses that might be slightly different, but I don't have time to delve into this at the moment.

Hope this helps.

Pete

[Graham Inchmead]

That's amazing, thank you, Pete.
It gave me really good start.

Your time and expertise saved me crap loads of time.

[Pete_UK]

Glad to help, Graham.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete