Results 1 to 4 of 4

Thread: Create a list that contains duplicate and unique names without blanks

  1. #1

    Create a list that contains duplicate and unique names without blanks



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have employees time card with Employee, location worked, ID number, hours, both regular and overtime hours and date worked. Iím trying to create a list of duplicate and unique listing of customer along with the associated information.


    In other words if employee 1, worked Monday, at customer 1, location it would appear once and if (2) employees worked, at customer (1) it would appear (1) time. The employee time is horizontal to the vertical listing of the customer name.


    The problem Iím having is (i.e.), is let say employee 1 and 2, are at customer 1, location on Monday, and employee 2, is back on Tuesday to customer 1, the formula I am using is removing the customer location on Tuesday from the list do to a duplicate name. (?).



    I have attachment showing the above information along with a table showing the table that Iím trying to create.


    I also really require a formula for this, if at all possible.


    Thank you, hope someone can help.
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Iced42 View Post
    Thank you, hope someone can help.
    It might not be what you're looking, but there I tried.
    See if you can help my idea
    Attached Files Attached Files

  3. #3
    WOW...! THAT"S IT!

    I have been on this for two weeks now.

    Can't thank you enough...

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,721
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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