Distinct Cells
Posted by Jeff on May 14, 2001 11:19 AM
I think this is an easy one... but I can't find the solution.
How do you count distinct cells?
I have a list of data - every row dated. I want to count the number of days I have entries for?
How do I do this? I know i've seen this out there...
Posted by Mark W. on May 14, 2001 12:11 PM
Can you provide some sample data?
Posted by Jeff on May 14, 2001 12:35 PM
Sure:
My list looks is somewhat like this-
2-May 22354 8:04
2-May 09482 8:10
2-May 02187 8:26
3-May 12947 8:02
3-May 39984 8:28
5-May 98301 9:35
etc...
How can I count how many days have entries? For example on the list above, there are 3 days with entries.
Any ideas?
JB
Posted by Mark W. on May 14, 2001 1:09 PM
Is your list sorted in date order as shown below?
If so, you can use...
{=SUM((A5:A10<>OFFSET(A5:A10,1,))+0)}
...this is an array formula that must be entered
using the Control+Shift+Enter key combination. The
braces are not entered by you, but rather supplied
by Excel to indicate that this is an array formula.
: Can you provide some sample data?
Posted by Mark W. on May 14, 2001 1:15 PM
If not sorted...
...you could use...
=SUM((FREQUENCY(A5:A12,A5:A12)<>0)+0) Is your list sorted in date order as shown below? If so, you can use... {=SUM((A5:A10<>OFFSET(A5:A10,1,))+0)} ...this is an array formula that must be entered using the Control+Shift+Enter key combination. The braces are not entered by you, but rather supplied by Excel to indicate that this is an array formula. : Sure: : My list looks is somewhat like this- : : 2-May 22354 8:04 : 2-May 09482 8:10 : 2-May 02187 8:26 : 3-May 12947 8:02 : 3-May 39984 8:28 : 5-May 98301 9:35 : etc... : How can I count how many days have entries? For example on the list above, there are 3 days with entries. : Any ideas? : JB
:
