I need some help getting an input frequency range 1-2000 to display corresponding switches in a switch calculator assignment without entering it one by one. Switches are A-P in Rows E3-E18 – frequency which is blank and manually entered entered is A3 [1-2000]. I want to list the frequency number small to large and corresponding switches.

I wish you all happy holidays, get some rest & take care ! 🙂

Mike, thank you so much for all of your videos. You made me love excel and thanks to this I pursued even further to visual basic, and pretty much that I want to be a programmer.

I'm wondering how you concluded the optimum point simply by calculating the CM at the vertices, when theoretically it could be on some other point along the slope? Is there some sort of rule for that?

I used math to prove that in this case, the optimum point is where x is maximum but is it true that in all cases, optimum point is going to be one of the vertices?

why do you say 700,000 (seven hundred thousand) when you show 70,000 (seventy thousand)

You are welcome and I only commented because I like your videos and wanted to make sure I was not missing anything.

Thank you so much Mike! Good job.

Very good, thanks a lot

Maybe it's easier that draw linear and then limit x and y. Just my opinion, but still, very good video,thank you!

I kinda like the 700,000 better. 🙂

Thanks for producing these videos Mike.

Your work is amazing. Very helpful! Thanks a lot

I need some help getting an input frequency range 1-2000 to display corresponding switches in a switch calculator assignment without entering it one by one. Switches are A-P in Rows E3-E18 – frequency which is blank and manually entered entered is A3 [1-2000]. I want to list the frequency number small to large and corresponding switches.

Hey Mike & The online excel team,

I wish you all happy holidays, get some rest & take care ! 🙂

Mike, thank you so much for all of your videos. You made me love excel and thanks to this I pursued even further to visual basic, and pretty much that I want to be a programmer.

Thanks for taking the time to put out these helpful videos. Has really helped me make some bad ass spreadsheets for engineering projects

thank you very much ^_^ it was magnificent

This entire playlist is amazing! Thank you Mike!

I'm wondering how you concluded the optimum point simply by calculating the CM at the vertices, when theoretically it could be on some other point along the slope? Is there some sort of rule for that?

I used math to prove that in this case, the optimum point is where x is maximum but is it true that in all cases, optimum point is going to be one of the vertices?