+ Reply to Thread
Results 1 to 3 of 3

Cross-checking list to determine overlap of entries

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Cross-checking list to determine overlap of entries

    Hello,

    I have a list of usernames and the website to which they have access. I need to be able to determine if a customer’s username is unique or if they have the same username for other websites. Some of the usernames are also duplicated for the same website. I've attached a sample file.

    Any help would be greatly appreciated in how I can complete a cross check using a formula.

    Thank you

    SampleFile.xlsx

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Cross-checking list to determine overlap of entries

    Hello,

    I used simple COUNTIF and COUNTIFS for counting Overlaps between websites and inside one website.
    Here is a sample of your file
    SampleFile.xlsx

    Hope this help.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Registered User
    Join Date
    03-06-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Cross-checking list to determine overlap of entries

    This is perfect. Thanks so much Lem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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