How to create a report for selected values in the column

S

Shreeshail Ganiger

Hi,

I have couple of columns in my Excel sheet.
Col1: Issues Nbr
Col2: Assingned to

Data:
Issues Nbr Assingned t
-------------------------------------------------------------------------------------------
123 Shreeshail Ganiger (Manager), ABC (Analyst), CGS
(Developer)
344 Shreeshail Ganiger (Manager), XYZ (Analyst), SDD
(Developer)
545 Shreeshail Ganiger (Manager), DED (Analyst), CGS
(Developer)
546 Shreeshail Ganiger (Manager), DED (Analyst), SDF
(Developer)

I am looking for data something like below

Assigned to Count(Issues)
--------------------------------
SDF 1
CGS 2
CGS 1
Shreeshail Ganiger 4
ABC 1
XYZ 1
DED 2

I am using Pivot table for all other reports and pivot table has this value.
I would like to automate this may be writing some macro.
Can any one please guide me how to do this.

Thanks in advance
Shreeshail Ganiger
 

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

How do I repeat labels in Excel for a pivot table field? 3
How to combine two column labels in a pivot table 1
How to transpose the table below into 1 (actually 2) column with t 1
Can I display the actual data in the data field of a pivot chart? 1
Creating a table with a numbered list in the first column 1
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
How to create list and count from a table? 1
Group Cell Contents in a Query or Report 1

Top