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.
Hi @Vicky92
In the expected output is the formula already applied? If yes for SL No 2 how is 62 largest ?
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.
Hi @Vicky92 - I believe the attached workflow will give you what you need. Let me know if you have questions.
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 😀👍
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 😀👍
Hi, @Vicky92
I stepped through this for you.
I hope you find it helpful. Cheers.
The packaged workbook with your input file is attached.
Thanks for the response @Vicky92
Please let me know if there anything else. Cheers!