View Single Post
Old 06-27-2012, 10:21 AM
Gary Drumm Gary Drumm is offline Windows XP Office 2007
Advanced Beginner
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road

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?
Reply With Quote