Hi, thank you for teaching me something new again. I usually use the GCD function for ratio's. Did not know about the ## trick. Leaning towards method 4 from now on.
Ratios?! I thought "back to the basics". But I was surprised; I learned many new concepts, i.e., the ##/## custom format, and the "Let". I REALLY do need 365. Thank you my friend (your name?😊).
A simple way would be to perform the GCD function in a cell somewhere off to the side (like cell M1), and then you could write a formula like the following: =Region1 / M1 & ":" & Region2 / M1
Not a subject much covered, thanks for something different, would never have thought about using custom formatting.
@@williamarthur4801 Trying to showcase the “not so everyday” features. Thanks for watching.
Another great video. I love the logic with which you solve this. Excellent, Bryon!!!
Thank you!!!
Methods 1 and 3 are very cool!!
Everybody has their favorites. It's so nice to have options.
Hi, thank you for teaching me something new again.
I usually use the GCD function for ratio's.
Did not know about the ## trick. Leaning towards method 4 from now on.
@@excel_along_the_way Awesome! Hope it makes your life simpler.
Ratios?! I thought "back to the basics". But I was surprised; I learned many new concepts, i.e., the ##/## custom format, and the "Let". I REALLY do need 365. Thank you my friend (your name?😊).
@@FsoOmar you are most welcome I’m glad you found something useful in the mix. (Bryon Smedley)
@@bcti-bcti Thanks Bryon. 🤝
Thank you! You mention there are (much) easier ways of doing method 3 then the LET function, I'm very curious about those:)
A simple way would be to perform the GCD function in a cell somewhere off to the side (like cell M1), and then you could write a formula like the following:
=Region1 / M1 & ":" & Region2 / M1
❤❤❤
@@sridharramadurai1206 So glad you enjoyed the video. Thanks for watching.