View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil[_17_] Neil[_17_] is offline
external usenet poster
 
Posts: 1
Default Counting Instances of a Value?

Hi there, i have a column, and within each column, it will either say:

Joe, Paul or Neil - and in the next column, it will have a value, i want to
count the values for each name

e.g.


A B

3 Neil
2 Joe
3 Neil
4 Paul


Neil = 6
Joe = 2
Paul = 4


I dont know how to achieve this ??


any help greatly apreciated,

Thanks,
neil