Quote:
You may be right there, but if so that is poor implementation of LET in my view. As with other instances, CF, row grouping, for example, the Excel guys have added functionality without considering for tables, even though they are pushing tables as the way to go.
I can only agree, another annoying issue is that you can't use array formulae in a table, the formulae are unable to expand the table, this is but another missed opportunity.
Quote:
No, that is horrible. It is referring to columns in the table by position not by name, which is wholly at odds with the rationale of structured tables.
Again I agree, however, this is the method I use quite a bit, only on tables where I know the structure of the table will not change.
Quote:
That is exactly what I am doing now, but that means that I reference the table name 3 times rather than just once, not good coding practice.