How to find Top & Bottom 5 Value in Excel

Hi,
Learn to find out top 5 and bottom 5 Value in Excel.
FILE Download:-
drive.google.com/file/d/1y44X...
Learn Pivot Table - • MS Excel - Pivot Table...
Learn Index & Match - • How to use Index Match...
Learn Number Formatting - • MS EXCEL - NUMBER FORM...
👉Subscribe Our Channel - / @datalearninghub
Topic covered in this video :
1) Large Function
2) Small Function
3) INDEX Function
4) MATCH List
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
#DataLeaningHUB #FindOutTop5Values
Our aim is to be making this channel is to make you expert in Microsoft Excel, Microsoft Word, VBA, SQL & Computer and Technology. You can easily learn Excel, Word, Computer in Hindi language. So don’t forget to Subscribe Our Channel.

Пікірлер: 14

  • @sreethulsuresh9165
    @sreethulsuresh916515 күн бұрын

    Using index match is difficult if 2 person have same salary index match function returns 1st name in 2 names

  • @yoyohoneysingh9176
    @yoyohoneysingh91763 жыл бұрын

    Really Helpful..

  • @mayurhatpale7383
    @mayurhatpale73837 ай бұрын

    Nice explanation

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad203 жыл бұрын

    loved it, sir

  • @DataLearninghub

    @DataLearninghub

    3 жыл бұрын

    Thanks

  • @Goyalharsh420
    @Goyalharsh4203 жыл бұрын

    🙏👌

  • @ExcelMadeEasy444
    @ExcelMadeEasy4443 жыл бұрын

    Great Explained.

  • @DataLearninghub

    @DataLearninghub

    3 жыл бұрын

    Thanks

  • @DataLearninghub

    @DataLearninghub

    3 жыл бұрын

    Thanks

  • @limbajiholkar2202
    @limbajiholkar22022 жыл бұрын

    This is possible if sheet is same but how in different sheet

  • @DataLearninghub

    @DataLearninghub

    2 жыл бұрын

    Same method will work

  • @virtualservicees9685
    @virtualservicees9685 Жыл бұрын

    What if there are ties in the data like two duplicate values in top 5, then the result will be incorrect, any solution?

  • @DataLearninghub

    @DataLearninghub

    Жыл бұрын

    Yes... It's possible

  • @tarunbidhuri6586

    @tarunbidhuri6586

    11 ай бұрын

    What will be the solution if it gives the same top 5 values. Let’s say two emp have same salary so the output value would be give 2 same values. Any formula to overcome that?