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.c...
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.

[@sreethulsuresh9165]

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

[@cricshillongguys8039]

what wil be the result if 2 emp has same salary?

[@mayurhatpale7383]

Nice explanation

[@BekarRasoi]

Really Helpful..

[@ubaidillahmuhammad20]

loved it, sir

[@DataLearninghub]

Thanks

[@Goyalharsh420]

🙏👌

[@ExcelMadeEasy444]

Great Explained.

[@DataLearninghub]

Thanks

[@DataLearninghub]

Thanks

[@limbajiholkar2202]

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

[@DataLearninghub]

Same method will work

[@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]

Yes... It's possible

[@tarunbidhuri6586]

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?