Excel Quick Tips - How to set absolute vs relative references to data tables in
Want to know how to set absolute vs relative references to data tables in Excel?
Well, Excel can be moody.
If you want to get it to behave in specific ways you have to understand how to tip-toe around its finicky behavior sometimes.
In this example we take a look at the often absolute, occasionally relative nature of references to data tables.
Here I show how to lock down columns/fields into actual absolute references by "double wrapping" the field we want to stay put in an extra set of brackets while letting the others stay relative to achieve our goal.
Have you ever run into this situation?
#data #analytics #excel #shorts
Follow for Excel tips, tricks and more!
📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/download...
👉 Connect with me on social! Linkedin: / mattbrattin Tiktok: / mattbrattin