Prev Previous Post   Next Post Next
  #1   Report Post  
Kevin Lin
 
Posts: n/a
Default Rating 1 to 10

Hi All,

Would someone please teach me how to input a formula that
could rate students grade. For example I got 10 students
and one of the student got 100 points is rated as no. 1
and 98 points is rated as no. 2 etc...

A B C
NAME POINTS RATING
Mike 75 3
John 60 5
Leon 100 1
Sam 98 2
Frank 74 4

Thank you,
Kevin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling hair out with VLOOKUP Confused Excel Worksheet Functions 5 November 22nd 04 05:05 PM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"