Comparison between multiple columns

[arunutp]

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.

[CharlieS · Accepted solution]

@arunutp

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.

[Kenda · Accepted 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!

[ponraj · Accepted solution]

Attaching a sample workflow for your case. 

Sample dataWorkflowResults

[arunutp]

Thank You

@CharlieS @Barnesk @Ponraj

All of the solutions works.

Thank You