vlookup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP? 3
Mail Merge with a many-to-one report/query 1
A Pivot Table challenge--I can't do it, can you? 5
Sorting within Groups 3
Vlookup help 2
Help with speeding up macro 5
Attendance list 1
Retrieve info from Dataset with Relations (Dataset,SQL or XML) 2

Back
Top