Re: Calculating frequency?
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 14:06:22 -0500
Hi!
One way:
Assume your 5 column table is in the range A1:E1000
Enter this formula in G1:
=ROWS($1:1)
Enter this formula in H1:
=COUNTIF(A$1:E$1000,G1)
Select both G1 and H1 and copy down to row 100.
Biff
"Ken" <PharmaThinkTankNS@xxxxxxxxxxx> wrote in message
news:1rGdnUc-m6Nr7uLenZ2dnUVZ_t2dnZ2d@xxxxxxxxxxxxxx
>I am trying determine how many times a number occurs a five column data
>***. They are between 1 and 100. I just can't get the formula to give
>me an answer. Can someone help?
>
> Lost in formuland-
> Thanks-
> Ken
>
.
- References:
- Calculating frequency?
- From: Ken
- Calculating frequency?
- Prev by Date: Re: Calculating frequency?
- Next by Date: Need assistance linking workbooks by date
- Previous by thread: Re: Calculating frequency?
- Next by thread: Need assistance linking workbooks by date
- Index(es):
