flojo_work
Board Regular
- Joined
- May 6, 2010
- Messages
- 63
<?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
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