I have a spreadsheet (imagine that) that in one column, I have a list of
names., for example, D10 = John, D11= Bob, D12= Bob, D13=Frank, D14 =
John etc, etc, etc,

Then in H10= Mary, H11=Mary, H12 = Sue, H13=Mary, etc, etc, etc

Now in cell B5, I want to know teh number of time John showed up in Column D
and in B6, the number of time Bob showed up etc, etc.
In E5, I need teh same thing, but for teh names that was in column H.


The names change, so hard coding for teh names wont work. Also, if it
would be possible to have it so the total gets added up as they are typed in
without having to run a macro after teh fact would be awesome.


Thanks in advance