Results 1 to 2 of 2

Thread: Can we get this with excel pivot table

  1. #1

    Can we get this with excel pivot table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Seeker michaelnicolas's Avatar
    Join Date
    Apr 2012
    Location
    Nicosia, Cyprus
    Posts
    11
    Articles
    0
    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.
    Attached Files Attached Files
    _________________________________
    Best Regards
    Nicolas Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •