Tuesday, November 5

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 *