What function returns the Nth position in a sequence of numbers?

  • Thread starter Thread starter Shiperton Henethe
  • Start date Start date
S

Shiperton Henethe

MS Excel 2002


Hi

What is the function that tells you (without doing a manual sort)
which position a cell's value is within a range of values?

I've used it before but I cant find it in Excel's Help !

With thanks


Ship
Shiperton Henethe
 
Look up RANK() in the Help files.
Pay attention to that third argument.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

MS Excel 2002


Hi

What is the function that tells you (without doing a manual sort)
which position a cell's value is within a range of values?

I've used it before but I cant find it in Excel's Help !

With thanks


Ship
Shiperton Henethe
 
Back
Top