Count number of instances
If you wanted to count the number of unique entries in that range, you could use
a formula like:
=sumproduct((a1:a10<"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in xl2007)
Curtis wrote:
Need a formaula to look at an entire column and count the number of
different times (say date of product)
Thanks
--
ce
--
Dave Peterson
|