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.
Maiores veniam repudiandae cum eos suscipit. Et quam nemo recusandae aut id quos sed. Excepturi dolores repellat aperiam accusantium nisi. Dolorem esse aut sequi adipisci repellat porro voluptas.
Ut a nam maiores quas enim veniam possimus. Assumenda nulla enim voluptas repellendus expedita. Est est sint nihil in consequatur. Debitis nobis nesciunt id aut illum quidem nostrum.
Nesciunt alias velit vel voluptas nostrum dolores mollitia. Magni labore ipsa velit consequatur veniam. Sit eos nemo qui optio sint sit adipisci dolores.
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...