Results 1 to 3 of 3

Ranking in Excel based on a scale of 1-10

Threaded View

KrisMI Ranking in Excel based on a... 06-20-2012, 04:39 AM
JBeaucaire Re: Ranking in Excel based on... 06-20-2012, 06:00 AM
KrisMI Re: Ranking in Excel based on... 06-20-2012, 06:43 AM
  1. 06-20-2012, 06:43 AM #3
    KrisMI
    KrisMI is offline
    Registered User
    Join Date
    06-08-2012
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Ranking in Excel based on a scale of 1-10

    Thanx for the reply

    It seems to work now. When you get the rank(with decimals)you run another rank function on that and then apply the trunc function to bracket the scores into 10& bands. As a fail save for all KPI's follow the same manner of going about it.Please see attached how to go about it. Thanks for the help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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