I cannot believe how painstaking and patient this was. I needed a tutorial with every keystroke explained. EVERYONE else wants to breeze through this stuff. For context, I'm blind, and I followed this entire thing completely. I don't know if blind people are who you had in mind, but this was phenomenal. I want you to teach me everything now! Now I'm wondering about using structured references in formulas like COUNTA and COUNTIF where I reference a whol column At least I have the confidence now to take a shot at it. Could have used an exit comment, though...
Plzz help me with this, Does table reference #all work in excel 2016. If is it work ,then why It shows me the #value error. And if not then in which version of excel does it work.
I am using version 365. When you enter the table name and the left bracket =TableName[ do you see the #All option? If not there maybe a problem with your table. Be sure it is actually a table. Make sure you are enclosing the #all within a left and right bracket [ ] and not parenthesis. You can also click on any cell in your table then click on Table Design on the ribbon's menu and verify that you are using the correct table name.
I use excel 2019 and got same error #VALUE! I got that error if I use #All, #Data, #Headers, but not if I use Table1[SomeColumn]. I also notice that array formulas not expand to more then one cell.
Sa is literally the first 2 letters of the words "sales table". When she types sa Excel filters the named ranges and tables etc for items beginning with sa and then she can double click on the selection she wants without having to type the whole thing out