I assume you mean the number of times a given entry appears in the whole
list. If this is what you want:
Try using the COUNTIF function.
In row 1 of some empty column type: =COUNTIF($A$1:$A$3000,A1)
and copy it down as far as your data goes. This assumes that the column you
want to count is Column A. As written, this formula assumes you have 3000
entries. Change that to your actual number of entries.
The formula produces a number in every cell that has the formula. That
number is the number of entries that your list has of the entry in Column A
in the same row. In other words, if row 17, Column A, has "Hello" in it,
the cell in row 17 of the column that has the formulas will have the number
of times that "hello" appears in your list. HTH Otto
