+ Reply to Thread
Results 1 to 3 of 3

Calculating Repeats not duplicates

  1. #1
    Registered User
    Join Date
    09-18-2011
    Location
    NJ, USA
    MS-Off Ver
    2007
    Posts
    8

    Question Calculating Repeats not duplicates

    I have a report that I have to do that requires me to determine how many times 2nd, 3rd, 4th time someone had to go back to a customer.
    Any assistance would be appreciated.
    Also, this will be used with a pivot table.
    Example:
    tech # 1 went to customer acct:969696 1/2/12
    tech # 2 went to customer acct:969696 1/5/12
    tech # 3 went to customer acct:969696 1/7/12
    tech # 4 went to customer acct:969696 1/13/12

    tech # 1 went to customer acct:777777 1/2/12
    tech # 2 went to customer acct:777777 1/5/12
    tech # 3 went to customer acct:777777 1/7/12

    I need a formula that will look at this data and say tech #1 had 2 repeats.
    I need a formula that will look at this data and say tech #2 had 2 repeats.
    I need a formula that will look at this data and say tech #3 had 1 repeats.
    I need a formula that will look at this data and say tech #4 had 0 repeats.
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Calculating Repeats not duplicates

    Hi dmatlof,

    Please see attached WorkBook.

    You will note that I had to assgin a unique number to each "Tech" to have something to work with.

    Do you really also need the Date besides the Account #

    Am I on track and can you use what I have done this far?

    If yes, maybe you can take it from here.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    09-18-2011
    Location
    NJ, USA
    MS-Off Ver
    2007
    Posts
    8

    Re: Calculating Repeats not duplicates

    I use the date to determine which tech was their first that way you can tell who has been there first.

+ Reply to Thread

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