Calculate how may times a number or text is used in a column

[Mark JH]

I am a novice at using Excel and I am unsure if the following can be done

I have two columns, one contains a mixture of numeric values, most of which are repeated many times. The other column is simular except that it contains words of which are repeated many times

Is there a way to calculate how many of each number or word are in there coulumns

ie
Numbers ----------------------------> Count Tota
1 1
2 2
3 3
4 4
3


1

 

[Frank Kabel]

Hi
have a look at the COUNTIF function.
you may also consider using a pivot table for creating a report for all
your entries