Results 1 to 5 of 5

RANK function question

Threaded View

  1. 09-05-2014, 11:47 AM #1
    bibu
    bibu is offline
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    304

    RANK function question

    In the attached, there are 500 names in order of ranking(column A) from 1 to 500
    I would like to assign each name a rating from 2700 to 1500 (column L) based on its ranking(column A)
    That means, for example the highest ranked (pos. 1) will have ~2700 rating, and the lowest ranked (pos 500) will have ~1500 rating.
    I've made a rough example in column C.
    Thanks for any help.
    Attached Files Attached Files
    Last edited by bibu; 09-05-2014 at 12:03 PM.
    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)

Similar Threads

  1. [SOLVED] Using the RANK function to rank decimal numbers
    By CRinne in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-29-2013, 02:14 PM
  2. [SOLVED] question regarding the RANK function
    By okcsteve in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-26-2013, 07:07 PM
  3. Rank Function question
    By ohtaryon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2007, 05:31 PM
  4. [SOLVED] rank question
    By Bill_S in forum Excel General
    Replies: 14
    Last Post: 04-23-2005, 03:06 PM

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