View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian Brian is offline
external usenet poster
 
Posts: 38
Default Count Unique Values in 1 Column based on Date Range in another Column

Howdy All,

I'm use the CountU function to count unique values in a column and it works
great!

Now what I want to do is count the unique values in Column B which occur
between a specific date range in Column A.

Column A contains dates from 2005 through 2009.

Column B contains Order Numbers for each date.

I want to count the unique values in column B for only 2008.

Any Ideas?

Thanks,
Brian