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.
> >