How to find new accounts come in with Match function.

[dhyun3]

Hi all,
Hope you all had great holidays.
Thanks in advance for your help.

Basically, we have a list of accounts that we can export from our data base, and everyday we have new accounts transferred into our data base system. I need to figure out which accounts are transferred over in a day-to-day basis. Of course, it's easy when we only have 10 accounts, but a number of accounts have been increased dramatically, and I figure I need to find an efficient way to do this.

Please take a look at the attached spreadsheet. From A2:A15, all accounts from yesterday, and from B2:B20, all accounts from today, we can easily see that some of accounts are just transferred over. Is there any way that I can use some formula to make this easy?

Thanks again.

[JeanRage]

Hi,

Indeed the match() function can help ...
see attached ...

HTH

[dhyun3]

Thank you very much!

[teylyn]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
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.