𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:
Employee | Salary
John | 75,000
Sarah | 60,000
Mike | 82,000
David | 90,000
Alice | 65,000

How would you return the second highest salary?

𝗠𝗲: Challenge accepted! 💪

=LARGE(B2:B6,2)

💡 Explanation:
The LARGE() function returns the Nth largest value from a range.
B2:B6 is the range containing salary values.
2 tells Excel to return the second largest value.
In this example, the result is 82,000.

This challenge tests your understanding of:
✅ LARGE()
✅ Ranking Values
✅ Statistical Functions

🎯 Expected Output Example
Formula: =LARGE(B2:B6,2) | Result: 82,000

🚀 Bonus: Return the Employee Name with the Second Highest Salary
For Microsoft 365 / Excel 2021:
=XLOOKUP(LARGE(B2:B6,2),B2:B6,A2:A6)

For older versions of Excel:
=INDEX(A2:A6,MATCH(LARGE(B2:B6,2),B2:B6,0))

These formulas return Mike, who has the second highest salary.

🚀 Tip for Excel Job Seekers:
Interviewers often ask questions involving the Nth highest or Nth lowest value. Make sure you're comfortable with:
• LARGE()
• SMALL()
• RANK()
• SORT()
• FILTER()

These functions are frequently used in dashboards, reports, and data analysis tasks.

❤️ React with ❤️ for more Excel interview challenges!