Results 1 to 4 of 4

How to find new accounts come in with Match function.

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2009
    Location
    maryland, usa
    MS-Off Ver
    Latest Excel (Excel 365)
    Posts
    30

    Question How to find new accounts come in with Match function.

    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.
    Attached Files Attached Files
    Last edited by dhyun3; 12-28-2009 at 04:11 PM. Reason: Change Title. I violated the rule.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1