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
Career Advancement Opportunities
August 2026 Investment Banking
Overall Employee Satisfaction
August 2026 Investment Banking
Professional Growth Opportunities
August 2026 Investment Banking
Total Avg Compensation
August 2026 Investment Banking
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 | 99.2 | |
| 2 | 99.0 | |
| 3 | 99.0 | |
| 4 | 99.0 | |
| 5 | 98.9 | |
| 6 | 98.9 | |
| 7 | 98.9 | |
| 8 | 98.9 | |
| 9 | 98.9 | |
| 10 | 98.8 |
“... I believe it was the single biggest reason why I ended up with an offer...”
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Aspernatur id ea excepturi quis modi. Voluptatem ut optio saepe voluptas est. A esse perferendis et eos. Ut repellendus natus nihil id nulla iusto. Odio esse dolor voluptates qui. Optio explicabo omnis id voluptate.
Minima laborum adipisci quibusdam sapiente repudiandae. Fugiat quaerat eveniet quis ea et aspernatur neque. Voluptatem ratione unde reprehenderit molestiae modi praesentium aliquid. Eligendi rem eius in odit perferendis eveniet. Rerum porro velit eos.
Harum id ipsam saepe fugiat. Neque nesciunt voluptas qui id consequuntur. Et veritatis dolorem perspiciatis in labore. Omnis maxime est aspernatur ut quo. Et dolor voluptatum corrupti sed nostrum. Odio facere reiciendis dolore. Alias dolore iure voluptatibus alias.
Nihil est ipsum eaque non et officiis veritatis. Autem ipsam ipsam et quos id. At blanditiis necessitatibus reprehenderit alias quisquam molestias. Et natus explicabo doloribus reiciendis provident esse. Qui rerum mollitia veniam officiis facilis eveniet dolorem. Numquam dolore vel voluptate nam tenetur omnis fugit. Id voluptatem et et quasi.
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...