Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Issue Tracker Counts

I've got a spreadsheet that has issue numbers in one column, 1 thru 999, 2nd
column is an assingee name, 3rd column is Priority.

What I'd like to do is summarize this on a seperate sheet, so it might look
something like this. Can I have Excel automatically populate a summary list
like this?

Jane
Prioirty Issue#
3-Low 1, 5, 4
2-Med 40
1-High 2

Joe
Prioirty Issue#
3-Low 3, 6, 8
2-Med 7
1-High 10

So on for as many folks as I have
Reply
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
Frequency tracker Mally Excel Discussion (Misc queries) 10 June 17th 08 02:14 PM
Mileage Tracker Ren Excel Discussion (Misc queries) 0 August 21st 07 03:56 PM
PlS Help ABT STOCK TRACKER ronald_peterson Excel Discussion (Misc queries) 18 June 1st 06 10:57 AM
MIS tracker Raj Excel Worksheet Functions 0 May 24th 06 02:38 PM
attendance tracker jennyn Excel Discussion (Misc queries) 2 January 11th 06 07:08 PM


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

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

About Us

"It's about Microsoft Excel"