6 Replies Latest reply: Dec 17, 2014 11:00 AM by Raghav Kumar RSS

    Numbering of rows in ascending order of values

    Raghav Kumar

      I am stuck with this problem.

       

      Each row has a value, Min(Value), Gap and Number.

      Value is an input.


      Min(Value) = Minimum among all values for each data point in Column 1.

      For eg. For A1 in the table below, there are 3 values. Minimum of these 3 values is needed in Min(Value)

       

      Gap = Value - Min(Value) for each row.

      Each data point is to be numbered in ascending order of Value.

                                                                             

      Column 1Column 2ValueMin(Value)GapNumber
      A1B13001002003
      A1B210010001
      A1B32001001002
      A2C2505001
      A2C110050502

       

      I could do till Gap. I used Group by to get Min(TDC) but I am unable to assign "Number"

      Any help is really appreciated.

       

       

      Regards

      Raghav