LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Count matching text in column

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count matching text in two columns Bob Phillips Excel Discussion (Misc queries) 2 July 4th 07 12:00 PM
how do I count the number of times text in column A matches text i Sheila Excel Worksheet Functions 2 November 16th 05 10:20 PM
matching the column b(sku)c(count)with A sammc2 Excel Worksheet Functions 0 November 3rd 05 07:42 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com Excel Worksheet Functions 9 July 31st 05 03:37 AM
How to count matching text Duplicateman Excel Discussion (Misc queries) 6 November 26th 04 08:40 AM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"