ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Issue Tracker Counts (https://www.excelbanter.com/excel-worksheet-functions/191545-issue-tracker-counts.html)

PopKracker

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


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com