Results 1 to 4 of 4

Thread: How to find out the rank against a number in excel sheet

  1. #1

    How to find out the rank against a number in excel sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Guys,

    I am facing a problem in the Excel Sheet attached along with this post. The scenario is -

    1. The user enters data in the cell C7.
    2. The program should check the value in the range from C9 to C18 and give a rank against the cell from Ranking Column.
    for eg: if the user enters '8' in C7 then ranking against value 8 is 4 as per 'Ranking' column. Now this rank '4' should get populated in the cell C20.

    I am unable to manipulate this formula since last 1 week. WOuld request you all to help me out with the same

    Regards
    Abhi
    Last edited by abhivics; 2012-09-25 at 01:56 PM. Reason: Failed to attach doc

  2. #2
    file attached
    Attached Files Attached Files

  3. #3
    In C20

    =VLOOKUP(C7,C9:H18,6,0)

  4. #4
    thanks a lot Tommy..!! its working..!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •