+ Reply to Thread
Results 1 to 11 of 11

How to calculate average based on text

  1. 10-24-2012, 03:25 AM #1
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    How to calculate average based on text

    Hello There

    I need help asap. I have a list of performane ratings on a drop down list and needs to get its average. This is how my sheet looks like.

    1. WORKING WITH OTHERS

    Competency and Definition Rating

    Exceed Customer Expectations Exceeds expectation
    Communicate with Others Exceeds expectation
    Demonstrate Team Spirit & Cooperatio Meets Expectation
    Act with Professionalism & Integrity Meets Expectation
    Resolve Customer Problems Meets Expectation

    2. TAKING RESPONSIBILITY

    Competency and Definition Rating

    Take Ownership Meets Expectation
    Learn, Develop, & Adapt to Change Exceeds expectation
    Work Independently Exceeds expectation
    Manage Time Meets Expectation
    Attend to Detail Meets Expectation


    At the end, i need the average result in its First Letter (e.g. M if answer is Meets Expectations.

    Thank You.
    Attached Files Attached Files
    Last edited by axendra12; 10-24-2012 at 03:40 AM.
    Reply With QuoteRegister To Reply
  2. 10-24-2012, 03:38 AM #2
    Sindhus
    Sindhus is offline
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: How to calculate average based on text

    Hi, Welcome to the forum.

    Please share a dummy workbook and provide an example.

    Regards,
    Sindhu
    Reply With QuoteRegister To Reply
  3. 10-24-2012, 03:41 AM #3
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to calculate average based on text

    Hi Sinhu. I have attached the worksheet i am working on. Kindly check if you could help me. Thanks
    Reply With QuoteRegister To Reply
  4. 10-24-2012, 04:14 AM #4
    Sindhus
    Sindhus is offline
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: How to calculate average based on text

    In the example, count of meets expectation and exceeds expectation are same. So, could you tell how to find average of it? Is there any scale you have to measure the total rating?
    Reply With QuoteRegister To Reply
  5. 10-24-2012, 06:16 AM #5
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to calculate average based on text

    Sorry for that. please see the revised attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 10-24-2012, 06:30 AM #6
    Sindhus
    Sindhus is offline
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: How to calculate average based on text

    Since there is no scale for computing average, i have taken the maximum occured value as the total rating. Assuming your reference to the list is in E column, i have used two supporting columns F and G.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-24-2012, 06:37 AM #7
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to calculate average based on text

    Thank u so much!! at least this is shorter than the ones ive done. ;p have a great day!
    Reply With QuoteRegister To Reply
  8. 10-24-2012, 06:45 AM #8
    Sindhus
    Sindhus is offline
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: How to calculate average based on text

    Please make this thread as solved, if your problem is resolved.. You too have a great day
    Reply With QuoteRegister To Reply
  9. 10-24-2012, 06:55 AM #9
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to calculate average based on text

    ok. i am so new to this. how can i mark this thread as solved?
    Reply With QuoteRegister To Reply
  10. 10-24-2012, 07:04 AM #10
    Sindhus
    Sindhus is offline
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: How to calculate average based on text

    Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.

    All these details are available under Forum rules.
    Reply With QuoteRegister To Reply
  11. 10-24-2012, 07:13 AM #11
    axendra12
    axendra12 is offline
    Registered User
    Join Date
    10-24-2012
    Location
    DUBAI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: How to calculate average based on text

    Done. Thanks!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1