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 columnDataPivot TableFinish
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.

--
Regards
Roger Govier



"Tom" wrote in message
...
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