Finding largest value from three columns group

[Vicky92]

Hi Team,

I have three columns of data, I have to select second largest number from three fields available. In nutshell, I have to use the above  excel formula which is as follows " =IFERROR(LARGE(C3:E3,2),"-")"

Can you please help me with the correct tool to be used. Sheet attached for reference purpose.

[atcodedog05]

Hi @Vicky92 

In the expected output is the formula already applied? If yes for SL No 2 how is 62 largest ?

[Vicky92]

Please read the my post it clearly says second largest number from three fields. If it not clear yet, I repeat need second largest number from three fields in a row.

[morr-co]

Hi @Vicky92 - I believe the attached workflow will give you what you need. Let me know if you have questions.

[atcodedog05]

Hi @Vicky92 

Here is a workflow for the task. Its consider 2nd largest

Output:

Workflow:

Hope this helps 🙂

however getting into the format you have is getting really challenging i am trying my best.

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

[atcodedog05]

Hi @Vicky92 

Here is a workflow which gets you output in desired format.

Output:

Workflow:

Hope this helps 🙂

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

[RobertOdera]

Hi, @Vicky92 

I stepped through this for you.

I hope you find it helpful. Cheers.

The packaged workbook with your input file is attached.

[RobertOdera]

Thanks for the response @Vicky92 

Please let me know if there anything else. Cheers!