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.
Solved! Go to 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