Thread: Cell Frequency
View Single Post
  #1   Report Post  
james
 
Posts: n/a
Default Cell Frequency

Is there a way to count the frequency of cell contents?

Example:
A B
1Smith Joe
2Smith Mary
3Jones Fred
4Smith Joe
5Jones Fred

I want this:
Smith Joe 2
Smith Mary 1
Jones Fred 2

Thanks for any advise.