Results 1 to 10 of 10

Uniue Values from 2 colums - Formula

Threaded View

ShaunDutton Uniue Values from 2 colums -... 05-03-2011, 04:56 PM
NBVC Re: Uniue Values from 2... 05-03-2011, 05:03 PM
ShaunDutton Re: Uniue Values from 2... 05-04-2011, 06:17 PM
mrice Re: Uniue Values from 2... 05-03-2011, 05:15 PM
NBVC Re: Uniue Values from 2... 05-04-2011, 07:50 PM
ShaunDutton Re: Uniue Values from 2... 05-05-2011, 06:48 AM
NBVC Re: Uniue Values from 2... 05-05-2011, 07:34 AM
ShaunDutton Re: Uniue Values from 2... 05-17-2011, 12:29 PM
nawas Re: Uniue Values from 2... 05-05-2011, 08:22 AM
NBVC Re: Uniue Values from 2... 05-17-2011, 12:44 PM
  1. #1
    Registered User
    Join Date
    05-03-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    4

    Uniue Values from 2 colums - Formula

    I am trying to determine the amount of days an employee has been at work. The employee's name & date can occur multiple times in the list of data. I would imagine you would need to find the unique number of occurences from a concatination between the 2 but that's not working for me.
    I would really appreciate it if i could use the formula for each employee...
    that way i could just copy the formula and reference the person's name.

    EG. Uniue days where employee name = "Rich Armstrong" (Answer should be 3)
    Uniue days where employee name = "Luke Siedle" (Answer should be 2)

    Here's the data...

    Date Name
    2011/04/01 Rich Armstrong
    2011/04/01 Luke Siedle
    2011/04/01 Rich Armstrong
    2011/04/01 Rich Armstrong
    2011/04/01 Rich Armstrong
    2011/04/01 Rich Armstrong
    2011/04/01 Luke Siedle
    2011/04/01 Luke Siedle
    2011/04/01 Luke Siedle
    2011/04/01 Luke Siedle
    2011/04/01 Luke Siedle
    2011/04/04 Rich Armstrong
    2011/04/04 Rich Armstrong
    2011/04/04 Rich Armstrong
    2011/04/04 Rich Armstrong
    2011/04/04 Rich Armstrong
    2011/04/04 Rich Armstrong
    2011/04/04 Luke Siedle
    2011/04/04 Luke Siedle
    2011/04/04 Luke Siedle
    2011/04/04 Luke Siedle
    2011/04/05 Rich Armstrong
    2011/04/05 Rich Armstrong
    2011/04/05 Rich Armstrong
    Last edited by NBVC; 05-17-2011 at 01:16 PM.

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