Number of Occurences In range

  • Thread starter Thread starter markawmaw
  • Start date Start date
M

markawmaw

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
 
Hi

you can use COUNTIF worksheet function in code itself

see Chip's site at cpearson.com

hth

Tim
 
Back
Top