Countif problem

[shano]

I have 2 columns in a database. One has a list of dates the other a
list of names. I can't figure out how to sort how many instances that
name correspondes with a date.

Example:

11/01 Adam
11/01 Adam
11/03 Adam
11/04 Steve

What I am looking for is 11/01 Adam 2, 11/03 Adam 1, 11/04 Steve 1

 

[Ken Wright]

A Pivot Table will do this for you - For a good intro:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm