| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Unique Values in 1 Column based on Date Range in another Column
Bernd,
Yes I got it to work, very interesting. The issue for me is that I the number of rows containing the data is large (around 20,000) and the number of rows varies. It does take some time to calculate on that many rows. Brian "Bernd P" wrote in message ... Hello Brian, Did you array-enter the formulas (finish with CTRL + SHIFT + ENTER, not only ENTER)? Please note that "Not you have your statistic for all years." should read "NOW you have your statistic for all years.". Regards, Bernd |
| 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
