I have a range in a worksheet and need to progmatically determine the
number of occurences of each piece of data.

Can anyone help me out please. As an example cells A1:A10 might
contain:

A1 Fred
A2 Peter
A3 Peter
A4 Fred
A5 John
A6 Simon
A7 Paul
A8 Mark
A9 Luke
A10 Simon

I need to return:

Fred 2
Peter 2
John 1
Simon 2
Paul 1
Mark 1
Luke 1