Results 1 to 11 of 11

How to calculate average based on text

Threaded View

  1. #1
    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.

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