Why does the table show in the formula and sometime it doesn't
Hello,
Attached is a screen shot a an example of my question.
The table may or may not be named. But I always have a header row for my table with a label naming that column. When I click to select the column *and* select the letter of that column I sometimes get the column label and sometimes get the name of the table::name of the column.
The attached screen shot show an example of this. The column letters are not important except for reference so we can call Rate Pay = A and Sick Pay B. When I put a formula in column C, I type out what I need to then allow auto fill to it's part then click A for column and again I click B for column. As you can see in one part just the name of the column is listed and in the other both the table name and the name of the column is listed.
Why? Whats is the difference? I get some differences when dealing with row too. And, just for those who are 'guessing' or opining, this inconsistency appears in all the equations I have used so far.
Thank you.
iMac 21.5″, macOS 10.15