Table Creation in EXCEL

[arunselvan]

Hi,

I have one requirement in EXCEL. I have no idea about how to use excel.\

I have below data in one excel sheet.

Sl.No.	Activity Type	Associate	Status
1	Development	Vidyashree	Approval
2	Development	Vidyashree	In progress
3	Data Consistency	Arun	In progress
4	Development	Naveen	In progress
5	Development	Shreyas	Approval

I want to create output table like below in another sheet of excel.
Above data can change often(like new associate or new activity type can get added in future).
As per above data, below report should change.

Sl. No.	Associate	Tickets	In progress	Completed	Approval
1	Arun	1	1	0	0
2	Naveen	1	1	0	0
3	Shreyas	1	0	0	1
4	Vidyashree	2	1	0	1
	Total	5	3	0	2
Sl. No.	Activity Type	Tickets	In progress	Completed	Approval
1	Data Consistency	1	1	0	0
2	Development	4	2	0	2
	Total	5	3	0	2

Thanks and Regards,
Arunselvan

[Paul_Hossler]

The easiest approach for someone who "I have no idea about how to use excel" would be to use what are called Pivot Tables

http://www.excel-easy.com/data-analy...ot-tables.html


In the attachment, I created a dynamic named range on the data table sheet which is the source for the two pivot tables

If the data table is changed or added or deleted the pivot tables need to be 'Refreshed' and you can do that using the right mouse button after you click inside the pivot table

I pasted two screen shots in the workbook, but you can delete them

[arunselvan]

Awesome Thanks.