Count matching text in column

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

Guest

I have a list of four thousand jobs in a column. Some of the jobs run only
once, some of the jobs run 9 times. There are at least 1000 different jobs.

How can I set up a table showing how many jobs (in text) ran once,
twice.....up to eight?

Thanks
 
Hi Tom

The easiest way would be a Pivot Table.
Assuming your column has a header of say Job Number
Mark your column>Data>Pivot Table>Finish
Drag Job Number to the Row area of the Pivot Table skeleton
Drag Job Number again to the Data area.
If it shows as Sum of Job Number, double click on that heading and choose
Count.
 
Back
Top