9 ай бұрын
Жыл бұрын
2 жыл бұрын
2 жыл бұрын
2 жыл бұрын
Пікірлер
@adilhassan987 3 күн бұрын
thanks very easy and i did it
@ExcellentDude 3 күн бұрын
Great!
@Roar_of_a_Lion 3 күн бұрын
THANK YOU!!!!!!
@ExcellentDude 3 күн бұрын
You're welcome
@ishramuaadh9510 8 күн бұрын
How to write formula for this equation.... If b2 greater then c2 then the results should come with + and how much value that increase For example : b2 is 40 c2 35 then results should come +5
@tavimihai3095 18 күн бұрын
Thank you so much ! You saved me !!
@ExcellentDude 18 күн бұрын
You're welcome!
@xlwatcher8885 21 күн бұрын
Is there a link to download the files to follow along? Thank you
@NMG1007 Ай бұрын
Thank you very much 😊 ☺️ 🙏
@ExcellentDude Ай бұрын
You are most welcome 😊
@soms42 Ай бұрын
for assigning values, vlookup is much easier and better then nexted if funtion
@muralis9759 Ай бұрын
Hello, thanks for the info & it’s amazing, I need another help with formula. I have 0 to 9 numbers & needs to pick 3 numbers from 0 to 9 in the separate cells. The 2nd cell number always should be greater than the first cell pick or it can be same or zero. Similarly with the cell 3 or 3rd pick. Can you please advise me how to do in the excel. I would be happy to connect to learn from you
@cubehire3653 2 ай бұрын
You are teaching excel formulas which is difficult for me concentrate on and you pipe in distracting music over the instuctions. I hate that you did that.
@ExcellentDude 2 ай бұрын
Thanks for your feedback. When I started my audio wasn't great so I added music to get rid of some of the background noise. Our upcoming videos will have no music
@RobCLynch 2 ай бұрын
I wonder if theres a way to select a column of numbers and have Excel display which numbers are cold/hot, so i can make a decision on numbers that might be overdue? So, although i am well aware that lotteries are random, there may be a way of using 'overdue' numbers as a long term strategy.
@ExcellentDude 2 ай бұрын
Yes, each draw is random. However, I suppose if you wanted to find "overdue" numbers ... Most lotteries publish historical lists of drawn numbers. You could scrape those numbers and pull in to Excel and find the least occuring numbers and use those as your "overdue" numbers. Good luck! If you win, think of the Excellent Dude. Cheers!
@RobCLynch 2 ай бұрын
@@ExcellentDude Thank you for your excellent reply.
@danijelakeserovic1134 3 ай бұрын
Well my symbol sign is not working that tab won't open what now
@divyanshagrawal7623 2 ай бұрын
Then u can't do anything have fun
@ExcellentDude 2 ай бұрын
Hi there. Could you give me more details of the issue you are encountering. I'm not sure what tab are you referring. The "Insert"?
@ronaldlawrence8777 3 ай бұрын
Worked great! Thanks Made my work a lot easier
@ExcellentDude 3 ай бұрын
Glad it helped
@dreamfyre1811 3 ай бұрын
Is there a way to generate a button to click instead of pressing shift+F9?
@ExcellentDude 3 ай бұрын
You could use VB and/or a macro to create a button to save you from having to do shift+F9
@Raonaidh 3 ай бұрын
Thank, exactly what I was looking for!
@ExcellentDude 3 ай бұрын
Glad I could help!
@JoesPhenomenal 3 ай бұрын
Cool.... Thanks for that. Will try this out and see what happens.
@ExcellentDude 3 ай бұрын
hopefully that solves the problem - if not, let me know and I can dive deeper into the file.
@rajeevmalur 3 ай бұрын
Thanks this was very helpful. Also, wanted to know if we can change the format to currency while we apply this formula?
@ExcellentDude 3 ай бұрын
You could adjust the "Increase Decimal" (below the Number Format drop down) to increase the number of zeros showing after the decimal point.
@ShelbyBryant 3 ай бұрын
so great!
@mahaboobkhalid3553 4 ай бұрын
Hi, Could you please make the UAE based lottory prediction calculations which works through previous draw results
@ExcellentDude 4 ай бұрын
Thanks for the suggestion! I'll take a look at the UAE Lottery
@naomii.m6539 4 ай бұрын
Well explained. Better than my lecturer
@ExcellentDude 4 ай бұрын
Thank you for the feedback!
@janicelayne9053 4 ай бұрын
I love the pace & depth at which you walk us through setting up these progress charts. Thank you so much!
@ExcellentDude 4 ай бұрын
Thanks for the kind words!
@Maddie-rh7zf 4 ай бұрын
Thank you; simple, brief, and helpful!
@ExcellentDude 4 ай бұрын
Glad it was helpful!
@dariknour6051 5 ай бұрын
First of all thank you sir. One thing, if I write a score of lets say 120, it returns an 'A'. So, how can fix the rage between 0-100?
@Matt-lc8qt 5 ай бұрын
This is super helpful. Never knew you could do something like this. Thanks! :)
@ExcellentDude 5 ай бұрын
Happy to help!
@drvmyslfcrzy 5 ай бұрын
This only works if you add the zeros first.. didn’t explain how to remove zeros that are there to begin with.
@markrationalthinker 6 ай бұрын
Cannot get this to work. Set it up exactly as you have it, but with a -/+ extended scale in the letter grade column. Anything that falls on the border is scored as the next lower grade: e.g., 93 should be an A, but is scoring as an A- and the range for A- is 90-92, with 90 entered in the center column.
@sexyshelly2011 6 ай бұрын
Hi! It’s there by chance a way you could help me design a lottery generator with specific filters? I know nothing about Excel but I do play the lottery and it would be much easier if I could create my own numbers to the print out and fill in my slips!!
@ExcellentDude 6 ай бұрын
I'm not sure if I can help out with your request. However, I'm sure there are online tools that could do that for you.
@herdityawahyu1250 6 ай бұрын
Got stuck several times, getting F for all grades. The solution is that the scoring table array - just like in this video - must be sorted/ordered from the LOWEST to the HIGHEST scores/grades. My mistake was that my scoring table array was sorted from the highest to the lowest... that's why I am getting all F... nice vid man, thanks!
@pratyushpillai 5 ай бұрын
great video + your comment was really helpful. thank you both :)
@harvey8695 7 ай бұрын
wouldn't it be faster to just copy the tables into one big table and insert a new pivot table against the new combined table?
@ExcellentDude 7 ай бұрын
It could be quicker if the data was static. However, what if the various tables were separate to support different business requirements (i.e. a table for the East, West, etc.) and were updated on a frequent basis? Then this solution would make more sense.
@floridaclaimersted5243 7 ай бұрын
😊😊😊😊😊
@ExcellentDude 7 ай бұрын
Thanks brother!
@ashrafctg 7 ай бұрын
Thanks a ton. Very helpful.
@ExcellentDude 7 ай бұрын
I'm glad it was helpful! Thanks for the comment!
@cardboardmusic 7 ай бұрын
Tried it several times, but never worked, so I gave up.
@ExcellentDude 7 ай бұрын
Sorry to hear that. Can you provide more details what is going wrong and maybe I can help get it working for you.
@cardboardmusic 7 ай бұрын
@@ExcellentDude Thanks for coming back so quickly. In the end I realised that using the IFS function worked just as well. BTW, I suspect that my problem was maybe using commas, instead of semi-colon.
@ExcellentDude 7 ай бұрын
OK - glad to hear you have a working solution. Cheers!
@andrejdebnar5065 7 ай бұрын
Instead concatenate, I can use & for simply conection of the cells, perfect :D
@scottblazicek7369 8 ай бұрын
Best example for What I was looking for!!! Thanks!
@ExcellentDude 8 ай бұрын
Glad it was helpful!
@CajunConstitution57 8 ай бұрын
Excellent! 😉 I've been trying to figure this out for nearly an hour. Your video was perfect!
@ExcellentDude 8 ай бұрын
Glad it helped you out!
@rockcrawler001 8 ай бұрын
Quick and easy... love it and it saved me a ton of time ☺
@ExcellentDude 8 ай бұрын
Glad it helped!
@BarryB468 8 ай бұрын
👍🏽
@pindol-nik 8 ай бұрын
This project is so versatile, with small changes can serve as dice roll simulator, so many uses. 🎲🎲🎲
@pindol-nik 8 ай бұрын
Great concept. Would it be possible to add score system for some symbols and combinations, with spin limits/credits. And button with refresh option? Thanks 👍🏻
@ExcellentDude 8 ай бұрын
Cool idea! It's certainly possible. Perhaps I'll add a Part 2 to this video and incorporate some of those ideas.
@parvezkhan-tv8ze 9 ай бұрын
Superb... I just got how to work with excel Thank you 😊
@ExcellentDude 8 ай бұрын
Great 👍
@BarryB468 9 ай бұрын
👍🏽
@ExcellentDude 9 ай бұрын
Howdy! Thanks for the view
@daltonlange6417 9 ай бұрын
hey alyssa
@nkirotemwaria6135 9 ай бұрын
Also only seeing Fs all the way down.
@ExcellentDude 9 ай бұрын
Hi there - the key is to make sure when you reference the scoring table on the right (in my video), to use absolute references (noted by $ signs) otherwise when you copy the vlookup formula to other rows, the vlookup will shift what it's looking at which will give incorrect results. Here's an example with absolute references - hopefully this is why your results aren't working (=vlookup(C4,$G$4:$H$8,2,FALSE). Let me know if this was the issue - if not, add your formula to the comments.
@cardboardmusic 7 ай бұрын
@@ExcellentDude I did exactly that and just got Fs and Es. BTW, I found a better solution, use the IFS function, it's just as good (and easier to use). Also, if in doubt use the function wizard, it's sometimes the formatting that causes the problems.
@jamesfoster7595 9 ай бұрын
Thank you for the video. Very informative. Quick question. I have values that total 100% but for some reason, I cannot get the % sign to be visible. Anything below 100% will show the % sign. Any suggestions? Thank you.
@ExcellentDude 9 ай бұрын
Hi there! Let me check my files (it's been a while since I did that video). It may be something as simple as making the font size a little smaller or increasing the size of the text box.
@BarryB468 9 ай бұрын
👍🏽
@ExcellentDude 9 ай бұрын
Thanks for the thumbs up Barry
@devilsgunner99 10 ай бұрын
Great video! how can I add more symbols to my draw results selection? For some reason I can't modify the group or delete it.
@ExcellentDude 9 ай бұрын
I haven't looked at that video in some time. But I'd imagine you'd need to add more options/symbols and then update any randbetweens and vlookups to account for the additional options.
@romeoh4859 10 ай бұрын
How can I set up multiple draws simultaneously? Like 100 draws with one press of F9
@ExcellentDude 9 ай бұрын
You could go to the Connections group in the Data tab and click "Refresh All" and then click Connection Properties where you could then set up a refresh for a specific time period. However, this would only rerun the F9 - not capture the results of each refresh. For that, you'd need to create a macro or use VB.
@roshnimudaliar9701 10 ай бұрын
Thanks
@ExcellentDude 10 ай бұрын
Thank you! I'm glad the video helped
@DaveHogg 11 ай бұрын
That's not a variable, it's a named constant.
@ExcellentDude 11 ай бұрын
Yes, you are correct that in this example it is a constant. However this could be applied to a value that is a product of dynamic calculation/external inputs/etc. I took the liberty of using the term "variable" just to make things more general.