This content has been marked as final. Show 6 replies
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 1||Column 2||Value||Min(Value)||Gap||Number|
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.