unique count

[flojo_work]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I have a set of data that has multiple columns where one column is a name and the second column is the date they attended a call, I want to show the number of days worked as they may have attended more that one call on a date I have used this formula to count the number of unique dates occurred, ; =IF(COUNTIF($D$2:D2,D2)=1,1,0)
Bottom of For but I have more than one name in the first column is there a formula I can use that will incorporate my count formula at each name change

 

[Aladin Akyurek]

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a set of data that has multiple columns where one column is a name and the second column is the date they attended a call, I want to show the number of days worked as they may have attended more that one call on a date I have used this formula to count the number of unique dates occurred, ; =IF(COUNTIF($D$2:D2,D2)=1,1,0)
Bottom of For but I have more than one name in the first column is there a formula I can use that will incorporate my count formula at each name change

Are you after?...

1) Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($D$2:$D$100<>"",
   MATCH("~"&$D$2:$D$100,$D$2:$D$100&"",0)),
    ROW($D$2:$D$100)-ROW($D$2)+1),1))

2) Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($D$2:$D$100<>"",
   IF($C$2:$C$100=F2,MATCH("~"&$D$2:$D$100,$D$2:$D$100&"",0))),
    ROW($D$2:$D$100)-ROW($D$2)+1),1))

where F2 houses an attender name.

 

[flojo_work]

sorry I dont quite undersand this reply how am I supose to enter the formula , its probibly me if I hold down the key as uyou instructed am I then supose to type the formula nothing seems to happen and if I copy the fommual in with the name I get N/A's

 

[Aladin Akyurek]

sorry I dont quite undersand this reply how am I supose to enter the formula , its probibly me if I hold down the key as uyou instructed am I then supose to type the formula nothing seems to happen and if I copy the fommual in with the name I get N/A's

Type the formula in a cell outside the data area, press the control and shift ket at the same time while you hit the enter key. If you do this properly, you'll see { and } appear around the formula.