Results 1 to 5 of 5

Formular to rank the first 5 lowest numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2016
    Location
    tanzania
    MS-Off Ver
    2007
    Posts
    319

    Formular to rank the first 5 lowest numbers

    Hi friends
    i hope you are doing well
    i have data in my work book with index number, names and marks. Marks are mixed randomly. I need marks to be ranked by taking a record of five first smallest numbers with their names
    i put it manual what i expected to see by shading with yellow colour from the real data and green colour to the expected result
    thanks in a lot.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rank lowest to highest using 2 columns
    By audax48 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-05-2020, 11:56 PM
  2. [SOLVED] IF formula that will rank numbers highest to lowest and then score them
    By slock92 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2017, 07:13 PM
  3. How to sort a single column from lowest to highest by using formular
    By issa.o in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-12-2016, 08:41 AM
  4. [SOLVED] [Help] Rank From Lowest to highest
    By gentle.diether in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2015, 08:21 AM
  5. Recording lowest and 2nd lowest numbers in a rang of cells
    By ORIELSON in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-01-2015, 10:31 AM
  6. Rank from highest to lowest
    By mastertonn in forum Excel General
    Replies: 7
    Last Post: 07-31-2014, 12:57 PM
  7. Rank where lowest value is highest rank
    By mile3024 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-09-2005, 07:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1