# Counting Number of Unique Names upon fullfilling Another Condition at Another Cell

1. ## Counting Number of Unique Names upon fullfilling Another Condition at Another Cell

Hi, I'd a question that bothered me a few weeks. My worksheet is like this:

Column A: Names of employees
Column B: Duty hours of that particular shift

What I want to achieve is: count the number of person, without duplicate, that worked duty shifts for less than 24 hours.
E.g. Michela worked 12 hrs, 8 hrs and 8.5 hour shifts, although all of the shifts are less 24 hours, but I just want to count them as 1 person, and extending to the column of data.

I'd also uploaded a sample of the sheet, which it showed "3 different person worked duty shifts less than 24 hours". Hope it helps in understanding.

Cheers

2. ## Re: Counting Number of Unique Names upon fullfilling Another Condition at Another Cell

it showed "3 different person worked duty shifts less than 24 hours
I see in your sheet only 2 persons with shifts less than 24 hours: Terry and Michela.

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Counting Number of Unique Names upon fullfilling Another Condition at Another Cell

Another option:

=SUM((--((FREQUENCY((IF(B2:B8<24,MATCH(A2:A8,A2:A8,0))),ROW(A2:A8)-ROW(A2)))>0)))

Confirmed with CTRL_SHIFT+ENTER

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

#### 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