LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default counting the number of occurences

I have a list that shows the worker ID and the result of each work item. The
number of work items differs for each worker ID--the results of each item is
either "A" or "D". This is an example of a portion of the list:

Worker Status
008Q A
008Q D
008Q A
098Q D
098Q A
098Q D

I am trying to set up a new list that counts for each worker ID the total
number of work items with status "A". How can I go about doing this?

Thanks. Let me know if you need more information on this.

 
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
Counting occurences of text DJ Excel Discussion (Misc queries) 7 September 24th 09 11:07 AM
Counting occurences of a name [email protected] Excel Worksheet Functions 3 October 8th 07 12:52 AM
Counting the occurences riomarde Excel Worksheet Functions 1 March 27th 06 09:00 PM
Counting Occurences Pete Excel Discussion (Misc queries) 7 May 2nd 05 08:28 PM
Counting Number of Occurences Darren Excel Discussion (Misc queries) 1 February 23rd 05 03:26 PM


All times are GMT +1. The time now is 09:54 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"