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.
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 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 .
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.
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 :)
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
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 :)
Nice one Jeff! Thanks for the detailed demonstration and walk through. Thumbs up!!
Thanks Wayne!
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 :)
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 :)
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 :)
I loved it, how you explain, please keep this up. You owe me one haha 😂.
Keep rocking.
awesome work
Good stuff Jeff
Thank you :)
Thank You Jeff!!
Amazing share! is there any change I can sort the table from biggest to smallest based on the Amt? Thank you!!
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 .
This is great! How would I sort by the amount column (largest to smallest)???
Great Demo, but the drill down is one of the pros in pivot table that cannot be replaced
Agreed!
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.
Endless possibilities ✌🏻
Indeed!!!!
beautiful!! 😅
Thank you :)
Nice
nice
hi Jeff! Are you still answering comments?
Could we send it by email after we create it?
Wow!
Will the VSTACK automatically sort?
No ... but in the video we used the SORT function around VSTACK to sort the results :)
What to do when HSTACK and VSTACK isn't working in my excel version?
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 😅
ｐｒｏｍｏｓｍ