How to find the Top 3 and Bottom 3 Values in Excel Data

Опубликовано: 12 Июнь 2023
на канале: digitidea
2,708
22

How to find the Top 3 and Bottom 3 Values in Excel Data
in this Excel tutorial video, I will show you how to find top 3 largest or bottom 3 smallest values in Excel data. This method can be used to find any nth value in a given set of values in Excel. We will use two functions of Excel to find out top 3 highest and top 3 lowest values in Excel. The functions are LARGE and SMALL functions of Excel and you will learn how to use them. Also you will learn how to selcet a colum quickly which has thousands of rows.