Another fantastic way to highlight numbers in a range/table. (TOPPIE) A very well thought out and structured approach and easy to adapt to the own needs. Thank you. Looking forward for more ....
JUST AWESOME!! I took a little break from keeping up to date with the new videos and I came back to such amazing project idea! I also think this would make a great new series - oriented around creating actual projects! There is little to none of such content on youtube with Excel.
Yeah, I agree. The issue is that the amount of time it takes to put one of those "project-based" videos together, versus the number of views it generates, is just not proportional. That doesn't mean I won't still try to make those kinds of videos, they just won't occur as often as hoped for. Thanks for watching.
Very nice project and masterfully explained. I personally would use the CHOOSE function instead of IF when referencing the option button linked cell output directly. IF always has to process the test and then return the true or false option whereas CHOOSE just run the option based on the index returned by the option button. Also CHOOSE is a charm where you have more than 2 option buttons grouped.
You are SO RIGHT! I should have done that. I just forgot about CHOOSE, and I love that little guy. I'm a dum-dum. Thanks for reminding me, and for watching.
Really nice! I have only two tiny changes to your solution. The first requires 365 and is the formula in the error message cell. I used: =XLOOKUP(1,S10:S11,T10:T11,"") Which is a tiny bit simpler and doesn't need the IFERROR function. The other thing I changed was the too high count message: ="Please select a Value less than the total number of sales entries: " & TEXT(COUNT(Sales),"#,###") I thought providing the maximum for N would be helpful. I had to extend the merged cells (one of the few times merging is acceptable since it requires two rows) to column M to fit the message. Still a great lesson!
100% Agreed! I prefer the XLOOKUP, but I try to make these as compatible as possible for the wider audience. Also, I thought about adding a "max count" notation, but it slipped my mind. Thanks for the reminder. Thanks for the contribution!!!
Another fantastic way to highlight numbers in a range/table. (TOPPIE)
A very well thought out and structured approach and easy to adapt to the own needs.
Thank you.
Looking forward for more ....
JUST AWESOME!! I took a little break from keeping up to date with the new videos and I came back to such amazing project idea! I also think this would make a great new series - oriented around creating actual projects! There is little to none of such content on youtube with Excel.
Yeah, I agree. The issue is that the amount of time it takes to put one of those "project-based" videos together, versus the number of views it generates, is just not proportional. That doesn't mean I won't still try to make those kinds of videos, they just won't occur as often as hoped for. Thanks for watching.
Love project videos where more than one Excel feature is covered. Looking forward to others.
@@StopWhining491 Glad you like them. I’m always worried that most people won’t watch a long-form video. Thanks for watching.
Excellent video, I'm going to pass a link to my 2 padawans in my office, so much great information.
When they take the pebble from your hand, they will be ready. (I'm mixing genres) Thanks for watching.
A very complete tutorial very useful for the company. Excellent work. Thank you for your time and for sharing.
I appreciate you saying so. Thanks for YOUR time, as well.
Very nice project and masterfully explained.
I personally would use the CHOOSE function instead of IF when referencing the option button linked cell output directly.
IF always has to process the test and then return the true or false option whereas CHOOSE just run the option based on the index returned by the option button.
Also CHOOSE is a charm where you have more than 2 option buttons grouped.
You are SO RIGHT! I should have done that. I just forgot about CHOOSE, and I love that little guy. I'm a dum-dum. Thanks for reminding me, and for watching.
@@bcti-bcti no way you dum, we all forget.
Keep up with what you doing, you have one of the most enjoyable Excel channels.
@@excel_along_the_way Thank you. That's high praise considering the company.
Very intersesting, no one explains like this. Thank you.
@@rotethongvanit I assume that is a compliment. 🤣 thanks for watching.
Awesome project. Masterfully explained.
Thanks a lot.
Really nice! I have only two tiny changes to your solution. The first requires 365 and is the formula in the error message cell. I used:
=XLOOKUP(1,S10:S11,T10:T11,"")
Which is a tiny bit simpler and doesn't need the IFERROR function. The other thing I changed was the too high count message:
="Please select a Value less than the total number of sales entries: " & TEXT(COUNT(Sales),"#,###")
I thought providing the maximum for N would be helpful. I had to extend the merged cells (one of the few times merging is acceptable since it requires two rows) to column M to fit the message.
Still a great lesson!
100% Agreed! I prefer the XLOOKUP, but I try to make these as compatible as possible for the wider audience. Also, I thought about adding a "max count" notation, but it slipped my mind. Thanks for the reminder. Thanks for the contribution!!!
So cool, thank you!!
You are most welcome. We appreciate your time.
You won a subscriber! Thank you very much!!
@@steliostsotras9050 That YOU for subscribing. It’s always nice to see the subscriber count go up. We appreciate you taking the time to watch.
Superb video...thank you...
Thank you for saying so. I appreciate your kind words.
This is great! Thank you for posting it.
Thanks for taking the time to watch and say nice things!!!
Poetry in motion. 😀
Thank you, loyal viewer. 😀
Like vdo
@@timestoryx Thanks. We’re glad you enjoyed it.
Create more projects
@@gagansingh3481 I’ll see what I can do. Thanks for the encouragement.