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
|