Thursday, November 21

Rank Function In Excel

  1. Open Excel File.
  2. Select The Cell Where you Want To The Result To Get Populated.
  3. Then Add This Formula In Particular Cell =RANK(10,A1:A10)
  4. There Is Third Optional Parameter (Ascending / Descending ) =RANK(10,A1:A10, 1 ‘For Ascending Order’) or =RANK(10,A1:A10, 0 For Descending Order)
  5. Make Sure To Lock The Range By $ Sign.
  6. Descending Order Is By Default Set Optional Parameter.
  7. That’s it 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *