Assuming that your values are stored in column A from cell 1 to 50, you
could use this formula in cell B1 and drag it down -
=RANK(A1,$A$1:$A$50)
HTH
Abhishek
On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote:
> Hi Experts,
>
> I need a formula to assign number value example is given below wh
Hi Experts,
I need a formula to assign number value example is given below where i need
is if the value is max then assign 4, below that 3, below that 2, below
that 1
Value 1000 1 100 10
required 43 1 2
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
