Legislative crooks

**Scribeman** · 03-06-2013, 07:52 PM

I'm a reporter in a state capital city who receives a daily email from the local jail of everyone who has been arrested that is quite long and in an Excel format. I also have a list of every lawmaker and statewide elected official. I want to compare the two lists on a daily basis to make sure our lawmakers aren't having too much fun. So my question is what function or formula would I need to compare the jailhouse list with the lawmaker list to see if there is a match in names? Once I have the function, I intend on writing a macros to make this a seamless exercise every day. Thanks for any help.

**Pete_UK** · 03-06-2013, 08:14 PM

So, your Mayor happens to be called John Smith and there also a John Smith who has been arrested - are you saying that you want these to be flagged as being the same?

Pete

**Scribeman** · 03-07-2013, 12:26 AM

Essentially yes. I want to be flagged that a John Smith was arrested. That allows me to look at date of birth and other identifying information contained in the jail log to determine if it's the mayor. Conversely, if 20 Smiths are arrested that day I don't want to miss John Smith.

**arlu1201** · 03-07-2013, 01:43 AM

Scribeman,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.