Sep 28 2022 12:11 PM
Sep 28 2022 12:11 PM
I'm not sure if this is possible to do, in the way I'm trying to do it, but I'm trying to do Conditional Data Validation with Multiple Conditions without making a Table separate from what the Personnel Roster already provides.
This is a multiple page document:
I have a "Roster" page where :
I have an "Allocation" page that has monthly duty positions that need to be filled.
|Bldg 2-ROVER 1|
|Bldg 2-ROVER 2|
|Bldg 3-ROVER 1|
|Bldg 3-ROVER 2|
Is it possible to, with only the information, as is, on the "Roster" page, create a conditional Data Validation List that: if Position cell A2=Bldg 1-OOD, then the data validation list in Cell D2 only pulls names who have the correct rank from the full Roster Column A?
Positions Pay Grades eligible for those positions
|Bldg 1-OOD||E6, E7, O1, O2, O3, W1, W2, W3|
|Bldg 1-AOOD||E4, E5|
|Bldg 1-DD||E1, E2, E3 (Additional requirement of having a license)|
|Bldg 2-DNCO||E4, E5|
|Bldg 2-ADNCO||E1, E2, E3|
|Bldg 2-ROVER 1||E1, E2, E3|
|Bldg 2-ROVER 2||E1, E2, E3|
|Bldg 3-DNCO||E4, E5|
|Bldg 3-ADNCO||E1, E2, E3|
|Bldg 3-ROVER 1||E1, E2, E3|
|Bldg 3-ROVER 2||E1, E2, E3|
|CACO||E6, E7, O1, O2, O3, W1, W2, W3|
Sep 29 2022 10:14 AM
It is not so easy to understand your table structure and which cell should now be formatted under which condition. Therefore, here is a not so detailed answer. Yes, it is possible to apply several conditions to one cell. You have to link the conditions with AAND() or OR(). For example like this:
At the end, TRUE must come out to trigger your formatting. If FALSE comes out, formatting will not take place.
If you can't do anything with this information, then I'm sorry. You would then have to explain your problem better. It would be best to upload a sample document with non-sensitive data.
Sep 29 2022 10:37 AM
I didn't really understand what you want to do exactly, but here is an example of a dropdown in dependency.
This might help you in your project.
Would also recommend, with your permission, to be as specific as possible about what the digital environment is.
Which Excel version, which operating system, which storage medium.
In addition, a file (without sensitive data) or photos would also help :).
Hope I was able to help you with this information & file.
I know I don't know anything (Socrates)
Sep 29 2022 03:05 PM
I honestly tried to upload pictures, and even the file itself, but keep getting told I don't have permissions.
Sep 29 2022 03:27 PM
Sep 29 2022 04:03 PM
Sep 29 2022 05:01 PM
Oct 01 2022 04:27 AM
Your new explanation sounds like you are getting somewhere with the FILTER() function.
Here you can filter out rows from a range of cells with one or more conditions.
Have a look at the help page for this.
By the way: If you are not allowed to upload files here, you can also use any other file hoster and post the link here.