Number of Occurences In range

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
 
T

Tim Childs

Hi

you can use COUNTIF worksheet function in code itself

see Chip's site at cpearson.com

hth

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Remove specific cells in a column. 2
remembering the same filtering criteria 13
How to delete ALL cells containing the same data 0
Which zones are touch given this range 2
How to delete ALL cells containing the same data --- REVISED 0
VBA Linest function for polynomial regression on horizontal range 0
Macro to add Multiple rows in same sheet 1

Top