Use a seperate worksheet to recreate the list of names in Column B, then insert this formula in Column A. It will look back to sheet 1 and count the occurances of that name in your column H.
=COUNTIF(Sheet1!H2:H1260,"Bob Jones")
Hope that helps,
Last edited by Gary Drumm; 06-27-2012 at 10:27 AM.
Reason: Better clarity?
|