This is How You Use Column Names in Excel Formulas

[@shoppersdream]

Nice, thanks!

[@Up4Excel]

Glad you enjoyed it 👍 John

[@michaelglen649]

This has saved me an enormous amount of time. In the past I would have written macros for some of this stuff (to find "last row" to fill to bottom of a column for example) - thank you!

[@Up4Excel]

Great to hear this Michael 👍. I find with time I do less and less with macros as more and more Excel features are added and I discover more.

[@FenderSidekick]

Thanks for showing how to do this. I am a developer who often uses excel to share data with stake holders but I wanted some quicker ways to save common formulas that I can reuse on exports where the columns are the same but may be in different ordinals. One thing I ran into is that if you have an underscore in the column name, you need to add another [] pair. [@[Column_Name]] as opposed to [@ColumnName].

[@Up4Excel]

Good spot and thanks for sharing. I'd imagine the safest system would be to always use the extra [ ] now I think of it.

[@subhraneelsaikia]

greatly appreciate the explanation of finer points such as adding tbl to table name and its obvious benefits. Without using tbl,i was not able to select the table columns,even after pressing tab

[@Up4Excel]

Thanks for your comment Subhraneel. Sometimes it's little tips like the one about adding tbl that can make a big difference. Glad you found my video so useful 👍

[@MortReany]

I'm glad to find your video about this topic. Thank you so much. I was amazingly useful for me. GL.

[@Up4Excel]

So glad to hear that Yevhenii. Thanks for saying so 👍

[@issaofmnl9317]

Thank you for sharing your skills as always. :)

[@Up4Excel]

No problem, glad you enjoy learning them 👍

[@dpgedward5947]

Nice one John

[@Up4Excel]

Thanks for the praise 👍

[@Tina-gp4rg]

Thank you so much.

[@Up4Excel]

You're welcome Tina 👍

[@kganesh3886]

Very Nice 😊 Sir.

[@Up4Excel]

Thank you! Cheers 👍