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