How to Find 2nd Smallest and 2nd Largest Number in Excel

preview_player
Показать описание
Please watch: "How to Transfer Files from Mobile to PC Without Using USB"
This video helps you to determine 2nd smallest , 2nd largest, 3rd smallest, 3rd largest, or kth smallest , kth largest number in a set of numbers.

This video contains:

how to determine 2nd smallest number in excel
how to determine 2nd largest number in excel,
how to determine any kth smallest or largest number in excel,
SMALL function in excel,
LARGE function in excel,
MAX & MIN function in Excel,
Рекомендации по теме
Комментарии
Автор

I have looked for hours to find a video like this. Thank you so much for your help!

enzorepetto
Автор

Thans a million for showing those functions.😃😃

aadarshsavaikar
Автор

I have looked for hours to find a video like this. I am wondering how it was simple, Thank you very much, I am very interested in, how we can find these numbers respectively without changing the K number!

babaksafi
Автор

If you want you can use left and right with if within those function so you don’t have to keep inputting the rank.

aadarshsavaikar
Автор

But this Formula is Not working on Duplicate Data..Please Suggest to Find 2nd and 3rd Largest

sourabh