View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pjr pjr is offline
external usenet poster
 
Posts: 10
Default How can I count how many times different texts repeat in a column?

Hey,

I have a column filled with text. there are about 100 cells in this column.
Those cells each have the name of a single corporation within them. many of
those corporation names are repeated throughout the column, but not all of
them.

How can I count the total # of corporation names present in that column?
i.e. if Vestcor repeats 20 times, it is only counted once; if Landmark
repeats zero times it also is counted once... etc.