Forum Discussion

PimK's avatar
PimK
Frequent Visitor
3 years ago
Solved

Rank column based on other text column

Hi all,   See below table, where I have a column Code (text) and a column Name. The aim is to rank the column Name based on the column Code. When column Name doesn't have a unique value, take the m...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PimK ,

     

    Since you don't want to change the Code column as number type. You need to first create column to return number type values.

    Then create a column to return min code value group by name.

    At last, create the ranking column.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PimK ,

 

Since you don't want to change the Code column as number type. You need to first create column to return number type values.

Then create a column to return min code value group by name.

At last, create the ranking column.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

PimK's avatar
PimK
Frequent Visitor
2 years ago

Thanks Stephen!