Excel Trick: Second Largest Value with FILTER + LARGE Formula 🔥

In this video, you will learn how to find the Second Largest value in Excel using the LARGE function combined with FILTER formula.

This method is very useful when you want to:
Find the 2nd highest sales amount
Get the second top scorer
Extract second highest value based on a condition
Work with dynamic filtered data
📌 Formula Used:
=LARGE(FILTER(A2:A10, B2:B10="East"), 2)
👉 LARGE(range, k) – Returns the k-th largest value
👉 FILTER(range, condition) – Filters data based on criteria
This trick works in Microsoft Excel 365 / Excel 2021.
If you are learning Excel from Basic to Advanced in Telugu, this video will help you improve your formula skills.

Видео Excel Trick: Second Largest Value with FILTER + LARGE Formula 🔥 канала GSDATALAB