If I name column A "StartDate" and then refer to cell A2, I would like the reference in the formula to look like "StartDate2" to make the formula more readable. But the reference remains "A2" as if the column didn't have a given name. Is there a way to make it happen? If not, what's the point with naming columns?
I have Excel 2016.
Create a proper table and then you will get proiper table references based on your column headers (Insert > Table).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Please update your profile, so that you get answers appropriate to the version you are actually using.Originally Posted by lotsof
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks