LinkBack URL
About LinkBacks
eepok 
Hello all,
I'm looking for a method to count the number of unique values (ID Number) within a selected date range. I know how to count unique values within a general range (=SUM(IF(FREQUENCY($A:$A,$A:$A)>0,1)), but the additional variable of date range is stumping me something fierce.
Here's some demo data:
Boarding DATE FAC/ST ID NUMBER DAY 7/3/2013 F 77306 WE 7/3/2013 F 77306 WE 7/9/2013 F 77306 TU 7/9/2013 F 77306 TU 7/10/2013 F 77306 WE 7/10/2013 F 77306 WE 7/11/2013 F 77306 TH 7/11/2013 F 77306 TH 7/12/2013 F 77306 FR 7/12/2013 F 77306 FR 7/15/2013 F 77306 MO 7/15/2013 F 77306 MO 7/16/2013 F 77306 TU 7/16/2013 F 77306 TU 7/17/2013 F 77306 WE 7/17/2013 F 77306 WE 7/18/2013 F 77306 TH 7/18/2013 F 77306 TH 7/19/2013 F 77306 FR 7/19/2013 F 77306 FR 7/23/2013 F 77306 TU 7/23/2013 F 77306 TU
Register To Reply
Bookmarks