Search each row for highest and second highest value, output column header and values

[mcas1]

Hi Community,

I am trying to achieve the following in my workflow: For every name, identify the winner and runner up, and how many pounds are associated with winner and runner up, and output the winner and runner up, as well as associated values. winner criteria needs to be flexible, but for now it is If #1 >= 2x #2 = No decision, ELSE decision. Below is an example.

Thanks very much in advance

Input:

	A1	B2	C3	D4
John	10	1	6	20
Mary	20		21
Sam	14	2	40	3

Output:

	Winner	Runner Up	Value for winner	Value for runner up
John	D4	A1	20	10
Mary	Decision Required
Sam	C3	A1	40	14

[atcodedog05 · Accepted solution]

Hi @mcas1 

Here is a workflow for the task.

Input:

Output:

Workflow:

Condition is set for each column in the formula tool.(i.e #1>= 2*#2)

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[mcas1]

Thanks so much! This was very helpful

[atcodedog05]

Happy to help 🙂 @mcas1 

Cheers and Happy Analyzing 😀