Another great solution to use on smaller screens or laptops. As always, your explanation is clear, ordered and documented in an excellent way. Very useful. Thank you.
I watch all of your videos when they come out. I use many of your solutions for specific things I am working on. This one I can use for a specific report. I changed the formula to a let function. =LET(hrow,(HSTACK("#",CHOOSECOLS(MyData[#Headers],1,3,4,5))), seq,SEQUENCE(25,1,K2+1,1), list,TAKE(DROP(CHOOSECOLS(FILTER(MyData,MyData[Region]=UserRegion),{1,3,4,5}),K2),25), row,HSTACK(seq,list), VSTACK(hrow,row))
My friend, you are singing my song!!!! I love writing single-cell, complete table formulas. It's so cool that Excel can do these things. It's a shame most users won't take the time to learn LET functions and all the associated functions. GREAT JOB!!! 10 out of 10!
You have made me discover the choosecols function. I'm wondering if some of the absolute reference (like "$C$1") could not be replaced by a "UserRegion" reference to improve its maintainability.
You are a natural Excel maestro. Thanks. You seem to skip mentioning the need to save the file as macro-enabled not as the regular xlsx.
Ah, that is an excellent point. I should have mentioned that. Thanks for letting me know.
Great video! The Sales Rep names made me chuckle
Thanks. I'm glad someone noticed. I wish I could use some of the more inappropriate names, but this is a family channel.
Just one word.... EXCELLENT!
Just one word....THANKS!
Another great solution to use on smaller screens or laptops.
As always, your explanation is clear, ordered and documented in an excellent way.
Very useful.
Thank you.
@@robbe58 Thanks. I’m glad you found it useful, loyal viewer. 👍🏼
I watch all of your videos when they come out. I use many of your solutions for specific things I am working on. This one I can use for a specific report. I changed the formula to a let function.
=LET(hrow,(HSTACK("#",CHOOSECOLS(MyData[#Headers],1,3,4,5))),
seq,SEQUENCE(25,1,K2+1,1),
list,TAKE(DROP(CHOOSECOLS(FILTER(MyData,MyData[Region]=UserRegion),{1,3,4,5}),K2),25),
row,HSTACK(seq,list),
VSTACK(hrow,row))
My friend, you are singing my song!!!! I love writing single-cell, complete table formulas. It's so cool that Excel can do these things. It's a shame most users won't take the time to learn LET functions and all the associated functions. GREAT JOB!!! 10 out of 10!
Great techniques! Many thanks.
Thank you for saying so. I appreciate you watching a long-form video.
I literally was wondering if something like this was possible yesterday. Amazing
@@skylineg6618 Perfect timing. Thanks for watching.
Great video!
Thanks! We appreciate you taking the time to watch.
@@bcti-bcti Thanks
The techniques are useful. I would have struggled to learn to subtract 25
@@TheMarkGross We’re glad you found them useful. Thanks for watching.
You have made me discover the choosecols function.
I'm wondering if some of the absolute reference (like "$C$1") could not be replaced by a "UserRegion" reference to improve its maintainability.
Great idea. The updated line of code would be as follows:
If Target.Address = Range("UserRegion") Then
Thanks for asking such a great question.
Love it, a handy scroll bar. Darn! I only have Excel 2021, but thank you, indeed.
Yeah, there are a few of these functions that require Office 365. Time to upgrade 😁