Great demonstration of the new excel functions HSTACK AND VSTACK. At Min 10 50 I said to myself: I am going to try that example using the LET function.. and and seconds later there it was: the LET function which in my opinion using the LET is cleaner and more elegant solution overall specially to troubleshoot the formula later . The drawback of this technique is that those new formulas have not been rolled to all excel users yet. Thanks for posting Jeff
Hi Jeff: Thank you so much. I really appreciate your energy and delivery style (and of course the content). I am just beginning to dip my toe in the LET ocean.
Awesome video and I learned a ton. My use case is a bit different and I'm having a problem. I have a column that I used to get a sorted number of unique values. I want to count how many time those unique values appear in another column. I do a countif function but I can't get the countif functions to continue down if I insert another unique value. I'm closer after this video, but the use case is slightly different.
Thanks Jeff for Nice & Clear Explanation !!! I have question ... How to create pivot table based on single cell report , keeping the source for PT Dynamic ??? Thanks In advance .
Hi jeff, let's say the itemnum has now change to month which contain past and future, I want to add a line where the month is this month to seperate the tense, how can I do that with conditional formatting, what is the formula?
This channel is so underrated. Amazing content!
Thank you :)
Great demonstration of the new excel functions HSTACK AND VSTACK. At Min 10 50 I said to myself: I am going to try that example using the LET function.. and and seconds later there it was: the LET function which in my opinion using the LET is cleaner and more elegant solution overall specially to troubleshoot the formula later . The drawback of this technique is that those new formulas have not been rolled to all excel users yet. Thanks for posting Jeff
Thanks for your kind note :)
Beautiful, these new functions seem to have enormous possibilities once we learn to use them.
Yes, I agree ... I'm sure Excel users will continue discovering cool ways to apply them :)
awesome work
Very thank you for this video, it is needed for me long time but today you solved my problems
Excellent news ... glad it was helpful :)
Hi Jeff: Thank you so much. I really appreciate your energy and delivery style (and of course the content). I am just beginning to dip my toe in the LET ocean.
Thanks for your kind note Jim ... and LET is a great way to organize large formulas and minimize duplication :)
Thanks
Jeff
Nice one Jeff! Thanks for the detailed demonstration and walk through. Thumbs up!!
Thanks Wayne!
Amazing video, thank you for sharing. The solution I have been looking for for some time, but had no clue. 👏💙
Thanks for your kind note, and glad it provided a solution :)
Great Demo, but the drill down is one of the pros in pivot table that cannot be replaced
Agreed!
Endless possibilities ✌🏻
Indeed!!!!
This is great! How would I sort by the amount column (largest to smallest)???
nice
Nice
Awesome video and I learned a ton. My use case is a bit different and I'm having a problem. I have a column that I used to get a sorted number of unique values. I want to count how many time those unique values appear in another column. I do a countif function but I can't get the countif functions to continue down if I insert another unique value. I'm closer after this video, but the use case is slightly different.
beautiful!! 😅
Thank you :)
Thank You Jeff!!
I loved it, how you explain, please keep this up. You owe me one haha 😂.
Keep rocking.
Thanks Jeff for Nice & Clear Explanation !!!
I have question ...
How to create pivot table based on single cell report , keeping the source for PT Dynamic ???
Thanks In advance .
Good stuff Jeff
Thank you :)
Amazing share! is there any change I can sort the table from biggest to smallest based on the Amt? Thank you!!
Will the VSTACK automatically sort?
No ... but in the video we used the SORT function around VSTACK to sort the results :)
hi Jeff! Are you still answering comments?
Could we send it by email after we create it?
Hi jeff, let's say the itemnum has now change to month which contain past and future, I want to add a line where the month is this month to seperate the tense, how can I do that with conditional formatting, what is the formula?
Thank you,
But why your voice like Jimmy Fallon 😅
ｐｒｏｍｏｓｍ