#shorts | Excel Formulas | How to Find 2nd Largest Value | #excel | #shortvideo

Today you will learn how to how to find 2ns largest value in excel in hindi.
In this tutorial, I am using one excel formula for finding 02 2nd largest value i.e. Large Formula and OrdinalNumber UDF as well as Conditional formatting .
This is an Excel tutorial for beginners or those who need to brush up on their Excel.

In case you are stuck, add your questions below in the comments section, and I will be happy to help you.

--------VBA Code---------
Function OrdinalNumber(num As Variant) As Variant
Dim MyNum As Variant
Dim Word(5) As String
Word(1) = "First"
Word(2) = "Second"
Word(3) = "Third"
Word(4) = "Fourth"
Word(5) = "Fifth"
MyNum = num
If Val(MyNum) 'Put Less Than Symbol Here' 6 Then
OrdinalNumber = Word(Val(MyNum))
Else
OrdinalNumber = ""
End If
End Function
---------------------------------------------------------------------------------
WATCH NEXT:

======================================================
Follow Me On Other Social Media
======================================================

If you liked the video Please Do Subscribe My Channel 😉
Keep Supporting me So I can Continue to provide you with free content each week!!
😇🙏

#StarExcelLearning #excelformulasinhindi #BasicExcel #shorts #shortvideo #excel

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for Watching!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬