Count appearences of a string

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

Hey guys,

I would appreciate some help in summarizing totals for the number of
appearences of a certain string (eg: www.catamaranservices.com) in a
particular column so I can work out which string/website appears the most
and allows me to rank them according to number of appearences:

This is what it currnetly look like:

D

Ladyanne2
Ladyanne2
Ladyanne2
Sabore
Sabore
Sabore
Sabore
southernpassage
southernpassage
southernpassage
southernpassage

....but I want it to come out like this:

D E
Ladyanne2 3
Sabore 4
southernpassage 4

....Is there a way to do this?

Many thanks
Jason
 
Jason,

Select your data, then use Data | Pivot Table... and insert the same item for both Row and Data fields, and you'll get a table of
counts for each unique item.

HTH,
Bernie
Excel MVP
 
Back
Top