Counting frequency of value in a range

[emm8080]

Hi again

I need a function to return the number of times a value appears in
column. The values are web addresses (visitors to a website) and
need to calculate how many visitors visited once only, how many visite
2-5 times, 6-10 times, 11-25 times, 26-100, and more than 100 times

eg

ColumnA
23.56.891.00
22.11.88.98
23.56.891.00


Once = 1
2-5 = 2


Thanks

Emm

 

[Guest]

Hi

Have a look at Data / Pivot Table. This is by far the best and easiest way
of summarising information. For an intro see here:
http://peltiertech.com/Excel/Pivots/pivotstart.htm