Excel Helpp pls
I have a data validation, with a list of locations, but every time I click a new location, the numbers stay the same.what do I have to do to make the numbers change as I click on each location???
I have a data validation, with a list of locations, but every time I click a new location, the numbers stay the same.what do I have to do to make the numbers change as I click on each location???
Career Resources
I'm not sure I understand what you are experiencing a problem with and without seeing the data or issue it is hard to help over the internet.
If this is a situation where you have a certain set of locations and data for each location, I might recommend using a combination of index & match. It's my go to solution for being able to type in a subject and quickly pull in the relevant information.
Porro sed dolor cum et. Culpa rerum odio placeat molestias et. Architecto aliquam doloremque enim numquam illo vel.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...