Man, you probably have no idea how much this helped me out. I was on the brink of going crazy before I found this. So thanks a lot!
@hogenkkalabhunk1798
6 жыл бұрын
Tee
@elphau
12 жыл бұрын
Hi Mike, I've been following your Excel for quite sometime now. My boss said I'm the Excel expert in the office, and I owed it you a lot. cos, i believe 80% of my excel skill come from watching your video. just wanna say thank you.
@excelisfun
12 жыл бұрын
I am glad that you like it, krn14142! Yes, I changed the production for the mic because I had some "pops" in this particular video. I also produced in HD - but it took 20 times longer (literally instead of producing in 1 - 2 minutes it took 20 to 30...)
@63ALEXGO
12 жыл бұрын
Mike instead of select the formula manual before pressing f9 to show the result of your formula you may select the section of the screen tip, excel will select the formula for you example in if(a1=b1,c1) you don't have to select the a1=b1 manually before pressing f9 in screen tip (if(logical test,value if true,value if false) just select logical test in the screen tip then excel will select a1=b1 for you you are a great teacher I learn a lots from your videos million thanks
@askni1985
12 жыл бұрын
There should not be any dislike button for all videos on this channel, thank you, your videos are much appreciated and there is a request, please make videos like this on access also
@Samy991188
3 жыл бұрын
Man, you probably have no idea how much this helped me out too :( , I was on the brink of going crazy before I found this. So thanks a lot! i'm following now all your videos.... thanksssssssssssss
@excelisfun
3 жыл бұрын
You are welcome, Abdelsalam!!!!
@Samy991188
3 жыл бұрын
@@excelisfun thanks
@Sumiyeco_boutique
12 жыл бұрын
This guy is a great presenter. Clear speech.
@daffy.
4 жыл бұрын
Ah man, this has literally saved my whole spreadsheet model. Thank you so much!
@fernleystephens2436
7 жыл бұрын
I've volunteered to be the treasurer of a local organization and have been busy building a spreadsheet to help me track our finances. I think of a feature I'd like to add but have no idea how to implement it but all I have to do is look through your videos and I'll find the answer. Thanks a lot for your help.
@827stormin
7 жыл бұрын
this video is beyond excellent. really helped me out on some of my projects. totally awesome. does a great job explaining it in easy follow along style. these current formulas and the set up is perfect probably for most people. hope him or someone would please post formula in the rank column to make it: 1,1,3,4,5,5,5,8, etc... with this added would make it complete and i believe a lot of people would really love it. the best without dispute.
@excelisfun
12 жыл бұрын
I am glad that you liked it!
@DannGillen
Ай бұрын
Really well done! Thank you for your clarity! You rock!
@excelisfun
Ай бұрын
You are welcome!!!
@DannGillen
9 күн бұрын
@@excelisfun Hello! I've deployed this in a cool poker calculator I have created, but have hit a roadblock with a next level application of this. I have gone to town on it and found some success, but keep slamming into an issue that I'm hoping you could help with. Would you be available to help me with this? Would email be best? Here's a general description: I have found a situation where I need to remove lines of the sorted rows based on a few conditions. I went through many IF/AND/ORs and many combinations thereof. I was successful in removing the rows that meet the conditions, but now the issue is that I cannot figure out how to elevate (if you will) the remaining rows to the top of the sorted list. Or how to re-sort the new list. I hope that's clear enough.
@excelisfun
12 жыл бұрын
You are welcome! I am happy it helps!
@aashishadhikari7194
5 жыл бұрын
You are too brilliant, no word to explain you how much you helped me, thanks dear
@excelisfun
5 жыл бұрын
Glad the videos help, Aashish!!! Thank you for your support with your comment, Thumbs Up and Sub : )
@mariachica2741
Жыл бұрын
you saved my life! THANKS!
@excelisfun
Жыл бұрын
You are welcome!
@excelisfun
12 жыл бұрын
I am glad that you like it!
@at-excel
12 жыл бұрын
The formulas are finished. I modified it, to show the ranks not in order 1,2,3,4,5,6 but in 1,2,2,4,5,5 if there are some ties. I used a time list and added an additional Rank.eq in Column C C6: =Rank.eq(a6;$a$6:$a$12;1) D6: =if(rows($d$6:d6)
@vipuljhaveri4805
4 жыл бұрын
Thank a lot , for your brilliant and lucid explanation , well advanced tricks made very easy for all with perfect presentation and with its download files to learn , practice and use , you are a unique mentor ! ! !
@excelisfun
4 жыл бұрын
Glad to help, vipul!!!!
@excelisfun
12 жыл бұрын
You are welcome! I am happy to help!
@Innovlrnr
Жыл бұрын
I am trying to consume this very valuable knowledge , and scratching my head too as it's not easily understandable for novice like me
@SANDYRUPA2006
12 жыл бұрын
I feel he is a great Teacher very easy to understand Keep it up Thanks a lot give us about more about Access
@omarrivera0108
12 жыл бұрын
Absolutely love learning in this specific modular approach. You are definitely a magician with this stuff! I'm so glad I came across your channel. Greatest example of knowledge sharing! You're making such a difference. THANK YOU!
@excelisfun
12 жыл бұрын
Wow!!!! That is TOTALLY amazing!!! I had no idea that it could work that way. Thanks for the great trick. I can't wait to make a video to display your amazing trick!!
@excelisfun
12 жыл бұрын
I am glad that the video helps!
@markmoscosa2371
12 жыл бұрын
That trick was Fantastic Mike. Admire all your passion for Excel and to share this knowledge with the Crew !
@Comehometoday
12 жыл бұрын
Great video! saves me whole day trying to figure out how to extract top 10 numbers with names from a pivot table
@excelisfun
12 жыл бұрын
You are welcome!
@excelisfun
12 жыл бұрын
Cool! I am glad that you liked the video!
@fajardiniarikamil2712
4 жыл бұрын
i did it ,it works and i dont know how it work but it gives me what i want
@at-excel
12 жыл бұрын
Thanks a lot for your comments on my KZitem channel. Now I'm looking for a way to show the correct ranks without column C. Still waiting for your next video, Andreas.
@excelisfun
12 жыл бұрын
Cool! I am glad that you like this video!
@excelisfun
12 жыл бұрын
I do not have a handout or video on the generic rules of how to put functions together. Sorry.
@ammarazizi9962
4 жыл бұрын
thank you so much! this really help me to analyze data much much faster!
@excelisfun
4 жыл бұрын
Glad this helps, Ammar!!!
@gustavoutz21
4 жыл бұрын
Wow this video saved my day. thank you!
@RobertLongM
5 жыл бұрын
What an amazing teacher you are!
@excelisfun
5 жыл бұрын
Glad you like it, Robert! Thanks for your support : )
@excelisfun
12 жыл бұрын
You are welcome for the knowledge!
@AhmadMustafaMohmedMetwalley
12 жыл бұрын
you are amizing ...this is summery for hundred of your vedios....thanks so much
@diamanthaxhimusa8103
12 жыл бұрын
You are amazing teacher. I admire you , you make me to love ,to woik in excel .. Thank you
@spawar7586
5 жыл бұрын
Very Good Sir, Its nice I like this. But I find the difficulty if we have same number then the name is repeating. Who we can over come if we are using Ms office 2013. Please help regrading this....
@lucaviglio1206
3 жыл бұрын
Amazing video... So helpful.. Thanks a lot Mike
@excelisfun
3 жыл бұрын
Glad I can help : )
@valeriamarano2188
8 жыл бұрын
I Love you!!!!! I've saved so many time!! You make my day!!
@shekhvasim249
5 жыл бұрын
What to do when in top ten more than 1 duplicate value
@excelisfun
12 жыл бұрын
Yes, you can make a re-make of it in German! Excelisfunner says hi to you!
@excelisfun
12 жыл бұрын
Wow! Beautiful setup with the RANK! I can't wait to see your video!
@YotesFan1980
2 жыл бұрын
Great video! It helped me with a leaderboard for a baseball stat. I have run into one tiny problem. How do I create a restriction with what you're doing at roughly the 8:00 mark to make a minimum appearance requirement? If, say, a pitcher needs 15 appearances to qualify for a percentage stat? With what I'm trying, the function returns the first guy it sees with the top-ranking percentage, despite the fact that he has only one appearance. Thank you in advance!
@dumpalakalki6897
5 жыл бұрын
Thank you sir today I learned new things from you
@anil11996
12 жыл бұрын
Your work is excellence
@SyedMuzammilMahasanShahi
6 жыл бұрын
Wow. That is amazing. Thanks Mike for this EXCELlent video.
@alaypaun
7 жыл бұрын
Dude, you just saved me hours of my life. Thanks for this, you're a legend :D
@ShahabUddin-qh5bl
4 жыл бұрын
Great video Sir, I am trying return value matching different columns but row function doesn't help
@susanwhite5009
6 жыл бұрын
Excellent video. So clear to follow and downloadable files to go along with the video... What could be better? I should've found this sooner. Thank you so much!
@ganeshkumarsit8671
5 жыл бұрын
Thanks a lot. It helped me very much
@excelisfun
5 жыл бұрын
You are welcome, a lot! Thanks for your support with your comment, thumbs up and Sub : )
@JavyD
12 жыл бұрын
This was amazing. Great Job! One of my favorites.
@6san6sei6
8 жыл бұрын
amazing trick. now i can make pareto charts fast and easy
@TheGK2009
10 жыл бұрын
Thanks!! This series is very helpful. Please keep posting these excellent excel tricks and tutorial. Regards,, GK
@levans13
6 жыл бұрын
Thank you for sharing this information! Worked perfectly!!!
@TruongTammie
11 жыл бұрын
You are awesome, the video is just exactly how i need it. Thank you so much!!!!
@askni1985
12 жыл бұрын
Thank you for the links
@excelisfun
12 жыл бұрын
It does seem weird, but it is the syntax that the COUNTIF function requires in this situation.
@RohitKumar-cc7zi
Жыл бұрын
Welcome Owsome bro just keep it up 👍👍👍👍 fabulous
@excelisfun
Жыл бұрын
: ) : ) : ) : )
@karolinaunderwood1039
5 жыл бұрын
this is great! thank you so much for your help. Do you think you could also show us how to improve this formula with two variables for small function? I am using it for the Risk register to pull out Top 5 risks. However, I need to apply an additional condition that pulls out only Top 5 risks which have the status "open".
@eLMaestroDos
4 жыл бұрын
Thank you so much for this sir this is really great..
@excelisfun
4 жыл бұрын
You are welcome, jhiechel1!!!
@shyamnilvk
7 жыл бұрын
Mate really appreciated, you help me a lot buddy. Thank you very much.
@norsalwati9138
4 жыл бұрын
Thank you so much this really helps me listing all the names with the tie marks. But can you please advise how do we do if we also want to rank the name of the tie marks based on other condition. For the example in your case, Moji and Hafiz have the same marks. can i ranking Moji and Hafiz based on other condition such as other marks? Thank you.
@s.kishoredina6241
4 жыл бұрын
Great wrk 👍👍 thanks for your vedio
@excelisfun
4 жыл бұрын
You are welcome, s.kishore!!!
@KennethTranMD
4 жыл бұрын
Wow, thanks a lot. That's very helpful.
@excelisfun
4 жыл бұрын
You are very welcome, Kenneth!
@KennethTranMD
4 жыл бұрын
@@excelisfun if i want D6:D10 to show 1,2,3,4,4 instead of 1,2,3,4,5. How could I do that? thanks
@ryanbauer3304
12 жыл бұрын
AWESOME!!! Thank you so much. I have been trying to figure this out for like a year :D
@buriskad
3 жыл бұрын
Is there a way to extract top values for displayed cells only? Amazing lesson btw, thanks!
@AVielot
12 жыл бұрын
Mike, wonderful video!.. I was wondering if you could maybe try a video of adding an additional criteria and then extract based on this additional constraint? For example, lets select the top 5 but eliminate the "Max" because it meets the criteria of an "outlier" ... resulting in an extract of only 4.... Scratching my head over this... but still trying to figure this out...
@havzz19
10 жыл бұрын
Hi, this is a really great show of how to use some of the functions! Will definitely be using this demo to help set up my data! Thanks :-))))
@guilhermefilho
4 жыл бұрын
You rule man!!
@excelisfun
4 жыл бұрын
That is so funny, this video is the video I am releasing tomorrow, Oct 4, 2019 as my Flash Back Friday. It is an oldie but a goodie...
@taintsweatnope5093
5 жыл бұрын
Thank you thank you thank you for your help with this!!!!
@excelisfun
5 жыл бұрын
You are welcome, welcome, welcome, J. B.!!! Thanks for your support on each vid with your comment, Thumbs Up and of course your Sub : )
@taintsweatnope5093
5 жыл бұрын
@@excelisfun In your example the area of return is the same size as the dataset whereas my area of return is much smaller. I am getting false outcomes and am wondering if that could be the cause. Any ideas?
@taintsweatnope5093
5 жыл бұрын
@@excelisfun solved it
@krn14242
12 жыл бұрын
Great comparison Mike. Your voice sounds a little different, better less background noise. Did you get a new mic or something? Thanks.
@barrieracingclub7097
4 жыл бұрын
This is amazing, i want to know if you have 5 times of the same manager with all different visit can he calculate from each manager and after rank them ?
@adnantahir4530
Жыл бұрын
Dear, please tell how can we use small function in the same sheet by leaving zero and counting from above zero
@prince4x4
4 жыл бұрын
Thanks u safe my life.
@excelisfun
4 жыл бұрын
Glad the video helps, Niti!!!!
@mybadongt613
11 жыл бұрын
On a different note, what if there are 3, 4 or 5 names or data that are the same instead of 2 same names as in the example? How would it be coded? Do you have a video of a variation of this??
@MichaelByrneWX
9 жыл бұрын
Is there a way to add date criteria also, I want to show two lists in my dashboard report, Top 10 last month and Top 10 last year. I refresh my data base table of transactions several times per month. p.s. I've learned fantastic tips and tricks from you over the years
@at-excel
12 жыл бұрын
Thanks for the great tutorial (again). I would like to produce a german remake of it. Greetings from Germany - also to ExcelIsFunner
@TheAnandcv
5 жыл бұрын
It is really nice. I could not get excel file. please give me exact link
@jeffwalls4530
7 жыл бұрын
Is there a way to put the number of visits in descending order instead of ascending order? In your example it would rank the least number of visits 1st and the most visits last.
@TheKinsayan
6 жыл бұрын
Great thanks ! And great formula !
@excelisfun
11 жыл бұрын
You do not want to use IFERROR rather then IF. Why? Because with an alternative logical test and the IF, the formula will not have to run the big array formula in every cell; with IFERROR the formula must run the whole formula in every cell. Although for small data sets, the calculation time saved is not noticeable, for large sets it is dramatic. It is efficient to use IF instead of IFERROR . Here is a video: Excel Magic Trick 1029: DON'T Use IFERROR, Use IF and Logical Test If Possible...
@excelisfun
11 жыл бұрын
I do not have a video on that particular situation. For back and forth dialog to get customized Excel solutions, try: mrexcel [dot] com/forum
@vijaysahal4556
3 жыл бұрын
nice sir 👍🏻👍🏻👍🏻👍🏻👍🏻
@excelisfun
12 жыл бұрын
That is too bad that you can't install 1013. But no worries, Excel 2010 or 2007 still are TOTALLY amazing!!!
@jimgaylord1004
9 жыл бұрын
Hi, great video. I posted a message but do not see it, so here it is again, hopefully not twice. Trick 967 is what I require for our baseball sandbag team to keep track of top players, etc, we have men and women and I would like to have a list of top 5 men players and a list of top 5 women players. I've tried adding a if statement but can't get it to work. What needs to be done in the formula to do this?
@excelisfun
11 жыл бұрын
Dates are serial numbers, so just use the number part of this video.
@ryanpreston6508
5 жыл бұрын
Hello - is it possible to have this work on the sum of a range? I.E If you have the same name repeat on another line, how could you have it sum the number of visits by the managers name and then rank?
@andersbruun1272
9 жыл бұрын
Hi, and thanks for a great video, it was a huge help for me. An additional question, is it possible in any way to add a secondary criteria, when making the top 5? Fx. when shooting clay targets. 20 hits in 20 shots. Then 20/21, 20/22, 19/20 and 19/21. That's the correct order, obviously 20/20 is better than 20/21. How can I make excel sort it out for me? Regards, Anders Bruun
@ianreassist8356
6 жыл бұрын
Hiya. This video is awesome as it is the answer to what I desperately need. But, I need to use it in google sheets and cant quite get it to work. Can anyone assist with this? Many thanks in advance.
@athanasiosbarmpas6392
6 жыл бұрын
Hi sir in the case of the tie can we add criteria also for the ranking?Thanks
@excelisfun
12 жыл бұрын
Thank you for the kind words. I always wonder what people are thinking when they dislike a video that has the sole intent of giving away free information in a reasonable way... I have some basic videos on Access: youtube [dot] com/course?list=ECB0DB785B9C9BE8A8 Great KZitem site about Access: youtube [dot] com/user/learnaccessbycrystal
@danmuir8626
11 жыл бұрын
Really good video but I have a question. What do you do if you have more than 2 duplicates? It comes up as an error every time.
@beingwise218
6 жыл бұрын
hi, i did it step by step followed all your instructions, but when all the values is changed to zero, then zahid appears to all cells in the manager column. How do we remove that and leave a blank cell when there are no number inputs on the visits column?
@iftekharraju318
5 жыл бұрын
excellent...thanks man..
@akademiks
12 жыл бұрын
Thanks for this tutorial.. I've got a question though. I'm having a difficult time logically putting together & branching Excel functions/formulas together.. Do you have any videos or PDFs where you basically go through the fundamentals of this? Right now, I'm at the point where I'm only really able to put multiple functions together by memory, and I'd really like to get a stronger understanding..
@deepk82
9 жыл бұрын
Great job, solved many problems :-)
@coolkidz33
12 жыл бұрын
At the 2:56 mark, I do not understand why you cannot just put =countif(A6:a12>=B2). Why does MS make us put it in quotes and then join it together? Seems like Excel should just be able to recognize the >= portion of the formula without making it ">="&. Really great video BTW.
@X-plaind
2 жыл бұрын
Hi. If you happen to read this. I am working on a data where I have to extract the lowest 5 numbers ignoring zeros. . How to ignore the zeros?
Пікірлер: 175