Question:

Microsoft Excel question...?

by  |  earlier

0 LIKES UnLike

please help me, how can I rank the values in Microsoft Excel from highest to lowest??? I want to rank my students from TOP 1 to the lowest... please help me...

 Tags:

   Report
Answer The Question I've Same Question Too

4 ANSWERS

Sort By: Date  |  Rating

  1. Use AutoFilter (Data > Filter > Autofilter) and then select the column you're looking to sort and pick the sort type.

    Easy Schmeasy...  


  2. Student in A1, score in B1. In C1 type =RANK(B1,B:B,0). Copy down as far as is needed. Sort on column C Ascending.

  3. this can be done by using IF function and the AND function.....

  4. technology-

    http://safetens.com/

You're reading: Microsoft Excel question...?

Question Stats

Latest activity: earlier.
This question has 4 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now
Unanswered Questions