I have been trying to get this for a couple of days now. I have read several articles on similiar achievements but have been unable to get any of them to work.
我已经试了好几天了。我读过几篇关于相似成就的文章，但没有一篇能让它们发挥作用。
Column A has a list of names that represent a person attending that work day; column I represent the date for that work day.
A列有代表参加该工作日的人员的名单;我代表那个工作日的日期。
I need to look through a date range for one week in "I" and get the unique count of names that were present in "A".
我需要在“I”中查找一个星期的日期范围，并获得在“a”中出现的唯一名称计数。
I can get the count but I cant get th unique count using
我可以得到计数，但我不能使用唯一的计数。
=COUNTIFS('DIRECT TIME'!I:I,">="&B25,'DIRECT TIME'!I:I,"<="&C25)
Can someone help me figure this out. I have tried to implement functions i have found online using frequency and sumproduct/count but have been unable to get any of them to work.
谁能帮我弄明白吗?我尝试过使用频率和sumproduct/count来实现我在网上找到的功能，但是没有一个可以使用。
Thanks,
谢谢,
-Joseph
约瑟夫
1 个解决方案
#1
1
Generically you can use a formula like this:
一般来说，你可以用这样的公式:
=SUM(IF(FREQUENCY(IF(Dates>=A1,IF(Dates<=A2,IF(Names<>"",MATCH(Names,Names,0)))),ROW(Names)-MIN(ROW(Names))+1),1))
=(如果(频率之和(如果(> = A1,日期(日期< = A2,如果(名字< > ",匹配(名字,名字,0)))),行(名字)分钟(行(名字))+ 1),1))
Confirmed with CTRL+SHIFT+ENTER
确认与CTRL + SHIFT + ENTER
Names and Dates should be the same size and as small as possible because the formula can be slow
名称和日期应该是相同的大小和尽可能的小，因为公式可能很慢
#1
1
Generically you can use a formula like this:
一般来说，你可以用这样的公式:
=SUM(IF(FREQUENCY(IF(Dates>=A1,IF(Dates<=A2,IF(Names<>"",MATCH(Names,Names,0)))),ROW(Names)-MIN(ROW(Names))+1),1))
=(如果(频率之和(如果(> = A1,日期(日期< = A2,如果(名字< > ",匹配(名字,名字,0)))),行(名字)分钟(行(名字))+ 1),1))
Confirmed with CTRL+SHIFT+ENTER
确认与CTRL + SHIFT + ENTER
Names and Dates should be the same size and as small as possible because the formula can be slow
名称和日期应该是相同的大小和尽可能的小，因为公式可能很慢