Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
About Count Function?
1 view
Skip to first unread message
shi
Feb 25, 1998, 3:00:00 AM2/25/98
to
Can I find ,or if there exists, a function which will count non-blank and
non-repeatly rows?
Thanks!
PeaceMaker
Feb 25, 1998, 3:00:00 AM2/25/98
to
shi <sh...@hotmail.com> wrote in article
<01bd41f1$149b7ca0$100970ca@a02>...
> Can I find ,or if there exists, a function which will count non-blank and
> non-repeatly rows?
> Thanks!
>
=COUNTA(will count all non-cells in the given range.)
Not sure what you want regarding non-repeating rows.
tod
Chip Pearson
Feb 27, 1998, 3:00:00 AM2/27/98
to
shi wrote in message <01bd41f1$149b7ca0$100970ca@a02>...
>Can I find ,or if there exists, a function which will count non-blank and
>non-repeatly rows?
>Thanks!
Use the following Array Formula (enter with Ctrl+Shift+Enter rather than
just Enter) to count the unique, non-blank entries in a range:
=SUM(IF(FREQUENCY(IF(LEN(UBRng)>0,MATCH(UBRng,UBRng,0),""),
IF(LEN(UBRng)>0,MATCH(UBRng,UBRng,0),""))>0,1))
Substitute your actual range for UBRng. UBRng may contain either strings or
numeric entries.
Cordially,
Chip Pearson
0 new messages