Excel Hash Sign Operator - What is it + ADVANCED Tricks! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Ravi
Hi ma'am,
I have seen very few people on the internet with such a clear demonstration of what one wants to portray.
The screen recording software is really impressive. The audio is super clear and audible.
When trying to create videos, I generally struggle with the audio part, though I get the video right.
It would be really kind of you, if you share with us the audio and video recording tools (both hardware and software) which you ae using to publish your content.
If it is a trade secret which you do not wish to share, then i am also ok with it.
Thank you for creating such wonderful content. Please keep up the good work.
Thanks again.
reply
Hi ma'am,
I have seen very few people on the internet with such a clear demonstration of what one wants to portray.
The screen recording software is really impressive. The audio is super clear and audible.
When trying to create videos, I generally struggle with the audio part, though I get the video right.
It would be really kind of you, if you share with us the audio and video recording tools (both hardware and software) which you ae using to publish your content.
If it is a trade secret which you do not wish to share, then i am also ok with it.
Thank you for creating such wonderful content. Please keep up the good work.
Thanks again.
reply
Emre
Mynda, thank you.
Besides, I have solved this tutorial by using INDIRECT function as below:
Source=indirect($C17$)
We are creating name list for each category and by using indirect function, we are converting this named list into data validation.
Named List-1: Clothing = -Socks\Socks\Jerseys\Tights-
Named List-2: Components= -Handlebars-
Named List-3: Bikes= -Road Bikes\Mountain Bikes-
Named List-4: Accessories = -Pumps\Helmets\Tires and Tubes-
when we are shifting category name from the C17 cell, indirect brings named list which matches with C17 name.
reply
Mynda, thank you.
Besides, I have solved this tutorial by using INDIRECT function as below:
Source=indirect($C17$)
We are creating name list for each category and by using indirect function, we are converting this named list into data validation.
Named List-1: Clothing = -Socks\Socks\Jerseys\Tights-
Named List-2: Components= -Handlebars-
Named List-3: Bikes= -Road Bikes\Mountain Bikes-
Named List-4: Accessories = -Pumps\Helmets\Tires and Tubes-
when we are shifting category name from the C17 cell, indirect brings named list which matches with C17 name.
reply
Jaswinder
It seems like the Filter function is most useful for people who work with categories that are in words. But what if you work with numbers in Excel? Is it possible to use the filter function to extract every quarters' data (e.g. month 3, month 6, 9, 12) from a table that has monthly data? (month 1, 2, 3, 4, ... etc.)?
reply
It seems like the Filter function is most useful for people who work with categories that are in words. But what if you work with numbers in Excel? Is it possible to use the filter function to extract every quarters' data (e.g. month 3, month 6, 9, 12) from a table that has monthly data? (month 1, 2, 3, 4, ... etc.)?
reply
Adam
=XLOOKUP(B17,$G$17#,OFFSET($G$17#,1,0))# Linking to the spilled array G17# for the Lookup Array and then offset that by 1 row for the Return Array worked for me. Also, I didn't know you could put # after a function that is awesome. Too bad the filtered categories aren-t dynamic.
reply
=XLOOKUP(B17,$G$17#,OFFSET($G$17#,1,0))# Linking to the spilled array G17# for the Lookup Array and then offset that by 1 row for the Return Array worked for me. Also, I didn't know you could put # after a function that is awesome. Too bad the filtered categories aren-t dynamic.
reply
gyozakeynesian
This is an INSANELY useful video. It's so clear, the examples are so good (esp that data validation one), and the hash makes spilled list so much more useful. Thank you Mynda! I'm going to teach my spouse this one as she would find it very helpful.
reply
This is an INSANELY useful video. It's so clear, the examples are so good (esp that data validation one), and the hash makes spilled list so much more useful. Thank you Mynda! I'm going to teach my spouse this one as she would find it very helpful.
reply
sergio
I'm a heavy user of Excel to simplify SAP reports and shows to our directors, many of them improved by your tutorials, thanks a lot, could you please create a video with MRP examples? I think there is an opportunity to develop all your knowledge in a file
reply
I'm a heavy user of Excel to simplify SAP reports and shows to our directors, many of them improved by your tutorials, thanks a lot, could you please create a video with MRP examples? I think there is an opportunity to develop all your knowledge in a file
reply
Mohammad
You are greater than the greats. Thank you and Mrs. Leila for this good work. You have widened the ocean of my excel from nearly knowing nothing to nearly an expert level. I sometimes think I live inside excel. Thank you for the good work.
reply
You are greater than the greats. Thank you and Mrs. Leila for this good work. You have widened the ocean of my excel from nearly knowing nothing to nearly an expert level. I sometimes think I live inside excel. Thank you for the good work.
reply
Sachin
For the return array, could you not dynamically reference to the lookup array that uses a hash, using other Excel formula?. That way no array is hardcoded? Or is that not yet possible. Great work btw!
reply
For the return array, could you not dynamically reference to the lookup array that uses a hash, using other Excel formula?. That way no array is hardcoded? Or is that not yet possible. Great work btw!
reply
Ernst
Thank you for this video. It clarified a few doubts. Question, could I just drag alongside the transposed data as well? But I guess it would not refresh if new data is added, would it?
reply
Thank you for this video. It clarified a few doubts. Question, could I just drag alongside the transposed data as well? But I guess it would not refresh if new data is added, would it?
reply
Vijay
Mynda, you have been -SPILLing- many secrets of Excel already, which have helped many like me immensely and this video is cherry on the cake! Thank you! --
reply
Mynda, you have been -SPILLing- many secrets of Excel already, which have helped many like me immensely and this video is cherry on the cake! Thank you! --
reply
Add a review, comment
Other channel videos
