Forum Discussion
Limit sum of entry in multiple dependent drop down list
Hello, I've set up a data entry sheet with 2 dependent drop down lists (using indirect data validation). Users are only allowed to select and then type in number only in the next cell. Users can...
I'm using Office 2016 on Mac OS.
Appreciate your reply, but I don't think it solves my problem. I want specifically to restrict people from going above the limit. As an example, I'm attaching a simple data set. So if you look at it, B and New York is selected in row 2 and 10. If they are selected, i don't want the total of these 2 to exceed a certain amount. Also, i don't know when they will be selected. It could be on row 1000 as well.
Unfortunately, I can't help you with Excel on Mac OS.
But think that some experts who are familiar with Excel on Mac OS will be in touch when they read your message.
Thank you for your feedback, your understanding and your patience.
Nikolino
I know I know nothing (Socrates)
But think that some experts who are familiar with Excel on Mac OS will be in touch when they read your message.
Thank you for your feedback, your understanding and your patience.
Nikolino
I know I know nothing (Socrates)