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
Using index match is difficult if 2 person have same salary index match function returns 1st name in 2 names
Really Helpful..
Nice explanation
loved it, sir
@DataLearninghub
3 жыл бұрын
Thanks
🙏👌
Great Explained.
@DataLearninghub
3 жыл бұрын
Thanks
@DataLearninghub
3 жыл бұрын
Thanks
This is possible if sheet is same but how in different sheet
@DataLearninghub
2 жыл бұрын
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?
@DataLearninghub
Жыл бұрын
Yes... It's possible
@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?