Results 1 to 7 of 7

Help require to modify this array formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Help require to modify this array formula

    Dear friends,
    I want to find out the first topper student in each subject. The formula is working fine if there are not same marks in subjects but if the two or more students secure same marks then it is not giving correct output. It’s taking the first student in series which I don’t want.

    The condition is:
    If two or more students secure same marks then the rank should be taken in the consideration. The top rank should be given first number though it’s not first in the series based on roll no in the result sheet.

    In this case the topper student in Marathi and Hindi is wrong output by the formula. I have given the correct required output table in the file.

    Please suggest me a modification in the formula.

    Any help will be appreciated.

    Thanking you,
    Attached Files Attached Files
    Sincerely,

    mso3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help require to modify the remark formula
    By mso3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-21-2014, 11:49 PM
  2. [SOLVED] modify array formula for additional arguments
    By neowok in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 08:14 AM
  3. Modify this array formula to correct #Num error
    By daymaker in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2011, 11:55 AM
  4. Modify SumIF... Array Formula
    By carl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2005, 03:06 PM
  5. [SOLVED] RE: Modify SumIF... Array Formula
    By Peo Sjoblom in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2005, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1