Counting number occurrences

T

thermometer

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

Ron Coderre

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
 
A

Ardus Petus

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
 
T

thermometer

Thanks to you both. Sounds like a good solution.

Therm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Top