| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in a entire column, not just range | Excel Worksheet Functions | |||
| count unique in one column based on two other columns | Excel Worksheet Functions | |||
| How do I count unique values within a date range? | Excel Discussion (Misc queries) | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Threaded Mode
