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

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
 
R

RagDyeR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is best way to determine whether a value exists in a column of values? 1
Position in a list of numbers 3
Count in a range of numbers 8
Any utilities to remove the ALL the Microsoft formatting tags? 84
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
OFFSET Function - what is it doing? 2
Update query to set value based on position in recordset 2
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2

Top