Counting number occurrences

I have almost 1000 rows of data that look like this:
Ounces1 Ounces2 Ounces3 Ounces4 Ounces5 Ounces6
20 5 18 50 6 35
49 22 20 43 10 3
41 6 27 23 47 19
3 12 47 51 2 10

How can I count the occurrence of each measurement? For example, I
would like to see something like:

20 Ounces - 100 times
51 Ounces - 202 times
etc.

It does not matter what column that are originally in - it's more like
a giant grouping of individual numbers.

Thanks for any assistance.

Try something like this:

G1: 20
H1: =COUNTIF(A:F,G1)

G2: 51
H2: =COUNTIF(A:F,G2)
etc

That will count ALL instance in columns A through F where a cell's value is
equal to the cell to the left of the formula.

Is that something you can work with?
Does that help?
***********
Regards,
Ron

XL2002, WinXP


"thermometer" wrote:

> I have almost 1000 rows of data that look like this:
> Ounces1 Ounces2 Ounces3 Ounces4 Ounces5 Ounces6
> 20 5 18 50 6 35
> 49 22 20 43 10 3
> 41 6 27 23 47 19
> 3 12 47 51 2 10
>
> How can I count the occurrence of each measurement? For example, I
> would like to see something like:
>
> 20 Ounces - 100 times
> 51 Ounces - 202 times
> etc.
>
> It does not matter what column that are originally in - it's more like
> a giant grouping of individual numbers.
>
> Thanks for any assistance.
>
>

Say your original data (without heders) is in A2:F5
Say you have 20 in A7
=COUNTIF(A2:F5,A7)
will return the # of 20's

HTH
--
AP

"thermometer" <thermometer98@gmail.com> a écrit dans le message de news:
1149611222.380354.25140@j55g2000cwa.googlegroups.com...
>I have almost 1000 rows of data that look like this:
> Ounces1 Ounces2 Ounces3 Ounces4 Ounces5 Ounces6
> 20 5 18 50 6 35
> 49 22 20 43 10 3
> 41 6 27 23 47 19
> 3 12 47 51 2 10
>
> How can I count the occurrence of each measurement? For example, I
> would like to see something like:
>
> 20 Ounces - 100 times
> 51 Ounces - 202 times
> etc.
>
> It does not matter what column that are originally in - it's more like
> a giant grouping of individual numbers.
>
> Thanks for any assistance.
>

Thanks to you both. Sounds like a good solution.

Therm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ardus Petus wrote:
> Say your original data (without heders) is in A2:F5
> Say you have 20 in A7
> =3DCOUNTIF(A2:F5,A7)
> will return the # of 20's
>
> HTH
> --
> AP
>
> "thermometer" <thermometer98@gmail.com> a =E9crit dans le message de news:
> 1149611222.380354.25140@j55g2000cwa.googlegroups.com...
> >I have almost 1000 rows of data that look like this:
> > Ounces1 Ounces2 Ounces3 Ounces4 Ounces5 Ounces6
> > 20 5 18 50 6 35
> > 49 22 20 43 10 3
> > 41 6 27 23 47 19
> > 3 12 47 51 2 10
> >
> > How can I count the occurrence of each measurement? For example, I
> > would like to see something like:
> >
> > 20 Ounces - 100 times
> > 51 Ounces - 202 times
> > etc.
> >
> > It does not matter what column that are originally in - it's more like
> > a giant grouping of individual numbers.
> >
> > Thanks for any assistance.
> >