How to find Top & Bottom 5 Value in Excel
Вставка
- Опубліковано 26 сер 2024
- 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.
Using index match is difficult if 2 person have same salary index match function returns 1st name in 2 names
what wil be the result if 2 emp has same salary?
Nice explanation
Really Helpful..
loved it, sir
Thanks
🙏👌
Great Explained.
Thanks
Thanks
This is possible if sheet is same but how in different sheet
Same method will work
What if there are ties in the data like two duplicate values in top 5, then the result will be incorrect, any solution?
Yes... It's possible
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?