Log In
Register
Home
February 8, 2020
Offline
Looking for suggestions. Prefer no VBA. I have one column that is a data validation list (Column A, Teams). Based upon the team selected from the Teams list, I need another data validation list to populate with their available position list (Column B, Position). For example, the position of Catcher has a requirement of needing 1 and that team already has a Catcher, I do not want catcher to show in the data validation list in Column B, Position). If the position of Outfield has a requirement of 4 and that team as 2, I need Outfield to show in the data validation list as available in Column B, Position.
Open to any suggestions. Thanks.
Trusted Members
December 20, 2019
Offline
Morining
Could you add an example workbook so that we do not have to recreate the data and to ensure that we understand what we are looking at?
Purfleet
February 8, 2020
Offline
See attached actual file. On the first tab, Input, when a team is entered (Column A), I need the Pos column (Column E) to only show their available roster positions based on the maximum position limits within the league.
The position limits are as follows:
C=1
1B=1
2B=1
3B=1
SS=1
CI=1
MI=1
OF=5
UT=2
P=9
Min=10
When a position limit has been reached, I would no longer like that position to show in the data validation list for the Pos column (Column E). I only want the available positions to show based upon the limits above. Thanks.
February 8, 2020
Offline
I was able to make this work with a combination of Powery Query (Get & Transform Data) and using INDIRECT with Data Validation.
I'm sure there are more efficient ways but at least it works.
1 Guest(s)
