Results 1 to 2 of 2

Thread: formulas to return specific info from pivot table

  1. #1
    Seeker robinssdawn's Avatar
    Join Date
    Nov 2017
    Posts
    7
    Articles
    0
    Excel Version
    2010

    formulas to return specific info from pivot table



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

    this pivot table is based on members who have posted in my music group per the music theme. I still have about 100 themes to add to the database and will also have more members to add to it who will have posted songs. Then i will update the pivot table accordingly, so the table is going to grow vertically and horizontally substantially and as i add the additional info, i need the following information to automatically change to reflect that.

    I am using Excel 2010. Not sure if this is applicable, but if it is, i am NOT interested in using the Slicer.

    On Sheet 1, at the bottom of the pivot table and off to the side are MAX formulas. Based on the max number of posts in each column, i need to know:
    1. whose name pertains to that max number
    2. also what theme that max number is.

    Next, i need to know which member has the highest number of posts in the entire pivot table and what theme the highest number of posts pertains to (cell addresses B33 and B34)

    then in Column V, i need to know what member received the highest number of posts and that theme that highest post is under.

    i show examples of what some answers should be in red.



    max formulas needed.xlsx

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,280
    Articles
    0
    Excel Version
    Office 365 Subscription
    Try this in V4 copied down:

    =INDEX(B$3:S$3,MATCH(MAX(B4:S4),B4:S4,0))

    or this:

    =INDEX(B$3:S$3,MATCH(U4,B4:S4,0))
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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