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

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

Workflow

Output

Help

Accepted answers

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 😀👍

All comments

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 😀👍

Thanks so much! This was very helpful

The pictures are not showing up.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703