vlookup?

T

tojo107

I have a spreadsheet with a thousand rows. It is separated by division, so a
persons name may appear in cell A1, then agin in row A967. (Always the same
column though). I want to get a count of how many times a person's name
appears on the report. What's the best way? The data is below.

Thanks for your help!1

Division: Eastern
BAILEY P0642325
BAILEY P0647801
User Id: BAILEY Total:
CHAMBERL P0628547
CHAMBERL P0644827
CHAMBERL P0648143
Division: Western
DILLOND P0597632
DILLOND P0638148
DILLOND P0638578
DILLOND P0638683
DILLOND P0640484
DILLOND P0647095
DILLOND P0647120
User Id: DILLOND Total:
 
Top