View Full Version : Can we get this with excel pivot table

2012-09-19, 06:35 PM
I have attached two sheets Data & Reqd Output. I want to know can we get required output with pivot table if yes ,then how can I achieve it or is there any other way for it

Kindly help .thanks in advance

2012-11-05, 10:00 AM
See attached.
I've added two additional columns (in red color) in your data range.
Also I've assumed that you need to count rather than sum the instances.