Issue Tracker Counts

P

PopKracker

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTable - Filter Row 0
Formula: Counting Cells on Different Worksheets 3
count if column A is 1-2 and column B is 03/02/08 to 03/09/08 4
Count unique with multiple criteria 3
IF and VLOOKUP functions for a matrix overview 4
Not sure whether to use VLOOKUP or an IF statement 2
Database questions, giving text a numerical value 2
Min/Max multiple rows into another sheet 1

Top