Counting uniques dates in a filtered column

**d_brian** · 10-24-2011, 01:21 PM

I need some help with a formula that will count the number of unique dates of a filtered column. I have attached the spreadsheet and highlighted the cell where the formula needs to be. Any assistance will be greatly appreciated.

**NBVC** · 10-24-2011, 01:35 PM

From http://www.j-walk.com/ss/excel/eee/eee020.txt

POWER FORMULA TECHNIQUES

by David Hager

---How can I find the count of unique items in a filtered column?---

Define a column range in your table (excluding header) as Rge.

Define unRge as:
=IF(SUBTOTAL(3,OFFSET(Rge,ROW(Rge)-MIN(ROW(Rge)),,1)),Rge,"")

Then, the array formula to return the # of unique occurrences in a filtered
column is:

=SUM(N(IF(ISNA(MATCH("",unRge,0)),MATCH(Rge,Rge,0),IF(MATCH(unRge,unRge,0)
=MATCH("",unRge,0),0,MATCH(unRge,unRge,0)))=ROW(Rge)-MIN(ROW(Rge))+1))

Try to adapt to your sheet.