Видео

I am really very thankful to you sir, i created my first progress chart step by step with your video

Hi please iv done everything right but help I can’t seem to generate new numbers by clicking F9 I’m using MAC

awesome dear

You saved my life!!

Excellent tutorial. Thank you.

I haven't watched it since I didn't find any Practice files.

What if it's a timing format?

Thank you for the video! Question: Is it possible to create two separate formulas on the same worksheet? One set for the 5 lottery numbers and the other for the Mega number. For example, the CA Powerball has 5 numbers ranging from 1 to 69. The MEGA number is only 1 to 26.

How do we use this to make automate payment method to the winner?

Complicated, loss me 🥺

Not working as =A1&REPT("0",8-LEN(A1)). But worked with ; so =A1&REPT("0";8-LEN(A1))

Could you create a formula for the pick four lottery I have a technique that’s bad ass just trying to figure out how to digitize the work out ???

Nice! 😊 It would be great if the final output looked something like the thumbnail. Will work out one towards that. By the way, how about a roulette simulator? 😁

Perfect. Just what I needed. Thank you!

We appreciate your work, l would like to create a different slots machine it will us six slots l got to trues my numbers, the win number most start by the smallest finish with the biggest, like (09,12.25,34,39,48)

Hey there excellent dude, How can I do this in apple please?

thanks very easy and i did it

THANK YOU!!!!!!

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

Thank you so much ! You saved me !!

Is there a link to download the files to follow along? Thank you

Thank you very much 😊 ☺️ 🙏

for assigning values, vlookup is much easier and better then nexted if funtion

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

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.

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.

Well my symbol sign is not working that tab won't open what now

Worked great! Thanks Made my work a lot easier

Is there a way to generate a button to click instead of pressing shift+F9?

Thank, exactly what I was looking for!

Cool.... Thanks for that. Will try this out and see what happens.

Thanks this was very helpful. Also, wanted to know if we can change the format to currency while we apply this formula?

so great!

Hi, Could you please make the UAE based lottory prediction calculations which works through previous draw results

Well explained. Better than my lecturer

I love the pace & depth at which you walk us through setting up these progress charts. Thank you so much!

Thank you; simple, brief, and helpful!

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?

This is super helpful. Never knew you could do something like this. Thanks! :)

This only works if you add the zeros first.. didn’t explain how to remove zeros that are there to begin with.

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.

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!!

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!

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?

😊😊😊😊😊

Thanks a ton. Very helpful.

Tried it several times, but never worked, so I gave up.

Instead concatenate, I can use & for simply conection of the cells, perfect :D