Hi ,
Input :
Output :
I would like to compare column 1,2,3,4,5 and output in "Result" , the column`s number with highest value among these columns but if columns have similar values as above then output should be the highest columns number.
Thank You in advance.
Résolu ! Accéder à la solution.
While it would be possible to do this with a single Formula tool, I recommend transposing the data first so any amount of columns can be accounted for (this time it's 1-5, maybe next time it's 1-35). I have attached a solution.
Hey @arunutp!
I would suggest using a Transpose tool first then using a couple Summarize and Join tools. See the attached workflow.
Hope this helps!
Thank You
@CharlieS @Barnesk @Ponraj
All of the solutions works.
Thank You