When Should You Use the Hash Sign in Excel Formulas?

Hello! Im a fan already of your works. May I ask on how I can use array/spill range as chart reference to be also dynamic? Thank you!

Permision me only gablesyou🎉🎉

Can an Excel table have a formula in its header? I want to have period 23-24 as table header in D4, which is drawn through a formula like =A4

Cool

Big fan. This is powerful. I'm a long time excel user and have a great grasp of macros etc. A bit hesitant to implement tables BUT is there a way to make dynamic charts extend when new data is added to a table? It's tedious to change chart series every time new data is added to a row in a table.....I tried with macros for a long time but never found a good solution.

Do you have any relationship with the founder of this excel tool? How do you get to know all these things

Question here, I've followed this and it's been a great help. I am trying to graph the number of times a unique phrase appears in my table. So I've created the table and then used the unique function to populate all of those cells. In the column next to that I inserted a countif function with the # to dynamically count every time these unique phrases appears. This has all worked wonderfully. Now, when I go to insert a dynamic chart, it does not update! I'm assuming this is because I have two separate dynamic columns that only update if the data changes. Am I missing something? Is there a way around this? Thank you!

Hi. Does anyone know how to get VBA to detect a spill error? I’m looking to detect and automatically insert rows but not found a solution yet.

What I would really like to see is the ability to use the spill functions to create a table. I love the use of the unique function but to use it I then lose all the table structure because it can't be inside a table. So my workaround so far is to have a column before the table with the unique function, then the first column of the table references the column next to it. The only problem I have is that I have to look back at the size of the table because it does not shrink or grow with records being added or removed. Any ideas on how I can get 1 table to use a unique() or filter() of another table to create its records?

DO YOU HAVE INSTGRAM SWEETIE

Hello,
How can I count how many John names I have in a row of 30 names? How can the answer be converted into a percentage? The name John is 15 times and how do you convert this answer into a percentage (50%) in a single formula.

Thank you

Really You Made it Simple and Easy

Excellent. Thanks

I am confused. You didn't explain what's a Spilled Range. 🤔

Hi, ma'am I am one of your subscribers. Is office 365 available in Afghanistan?

Thank ya

Thanks for the explanation of using the # operator. Can we use this table (derived from # operator) to calculate % changes in the table

Do you know why I can't use the hash sign # inside certain formulas? For example, I have spilled ranges in A1:A10 and B1:B10 and in C1 if I enter =MAX(A1#,B1#), the formula does not spill down to C10.

im getting a spill error from xlookup which source & target are the excel table. how to fix this?

I literally thought this was a video discussing putting weed in baby milk..

Thank you for your time.

only when smoking hash.

I need hash before solving a math problem.

Now we have also @ in formulas. Can you explain about it, please?

How would you then sum sales by F&G in day column H? And have that run down if new things are added to the table?

Definitely useful...I am just picking up on a lot of Excel functionalities lately...wanna step up my Excel game for the future (taken up your Udemy course on VBA, too😊)....BUT...that bonus tip...Leila....that's simply awesome...I am still in awe of how there are so many Excel tricks and tools that APPEAR so simple...but the time and effort they can save us...really really great! Thanks for this.👍🏻🙂

In Excel, we are never the masters, merely the students.

What a clever and beautiful young woman! I'm impressed! I remember the first MS Excel, how far the thing has gone!

classroom symbol commonecation software speak quality utility year 2022 2023 room 🏛🌍🌎🌏

that is really great, thanks

What would be the difference compared with naming ranges?
Thank you very much for your amazing videos!

Hi Leila, I want to index 1 column of a table, but have it spill into columns of ten and whatever remains, can u help?

Another very useful video! Thanks for sharing!

I use Excel at my office for simple things yet thanks to your videos I learned how to do my job faster and in more precise way. Thank you!

Please show us how to copy/paste 15 and 20 digit numbers (IMEI and SIM numbers).

I didnt expect THAT type of hash.

That’s called a number sign.

Seems the symbol should be referred to as an octothorp when the context is just the general symbol (as opposed to a particular use of it). If referring to weight, call it a pound symbol, in social media a hashtag, when quantity, number symbol. Of course not many will know what you're talking about. :)

answer when you need it? if not why use

Don't you mean the "pound sign"? Come on, be professional.

Hi thank you for your videos. I learn a lot from you. More please.

Great!!! Thank you! :D

I remember when # used to be called the Pound Sign!

Wheres the video for the pratical example