arunselvan
02-21-2017, 07:00 AM
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
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