Using # for Dynamic Ranges

[NYEXCEL1]

I recently found an article on using Hashtags in formulas to build dynamic ranges. I have Microsoft 365 but the hashtag does not work, does this feature need to be "turned On" somewhere in options ? Thank you

 

[MARK858]

Have a look at the link below, it explains the use of the Hash symbol in formulas

When to Use the Hash Sign (#) in Excel Formulas

What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

www.xelplus.com

 

[Fluff]

I have Microsoft 365

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[NYEXCEL1]

Have a look at the link below, it explains the use of the Hash symbol in formulas

When to Use the Hash Sign (#) in Excel Formulas

What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

www.xelplus.com

Appreciate the read. However, Im still getting a REF# error.
If I have a set of data and to the right I have the formula =FILTER(A3:C15,(C3:C15=G4)) I get a nice array output. The problem is that i want to use the # after just A3 and C3 incase i want to add future row to the data set. I tried also making into a table but it didnt work? any thoughts?

 

[Fluff]

As the article says, you can only use the # sign if the cell is the first cell in a spill range.
So unless A3 is a spill range you cannot use A3#