Results 1 to 3 of 3

Excel 2007 : Determining which action had highest average score

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    341

    Determining which action had highest average score

    Hi,

    I hope you can help me figure out how to do this. I want Excel to pull the text string that had the highest associated average score for a certain actor and display it. Sound simple? Well it isn't I think

    So here's the scenario:
    • 50 people assigned an ID 1-50
    • 1500+ different actions which are text
    • Satisfaction with an action ranked 0-10

    What I would like to do is this:
    1. Reference a cell which contains the ID (1-50) for a given actor (already done)
    2. Then average all satisfaction scores per action for this actor (i.e. Jumping has 3 entries for the actor, rated 0, 6, 9, average that keeping in mind there's a host of different actions)
    3. Return the name of the action with the highest average in cell A
    4. Return the average value of the action in cell B
    5. Return the number of this action counted in cell C

    Repeat for the next 4 highest averages top create a top5 highest average list of actions.

    Please let me know if I need to clarify this further!

    P.S.:
    ID (actor reference) is already given on the current worksheet. It references AS:AS of Sheet1. The ID can be changed on the current worksheet to produce a report for different actors on the current worksheet. This is already in place.
    Action is found on D:D of Sheet1
    Satisfaction score is found on H:H of Sheet1

    ReportTest2.xlsx
    Last edited by dip11; 12-06-2011 at 06:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1