Afternoon,
Looking for 2 data validation formulas for:
1. Drop down menu (E2) to list only distinct values from "Agency" column. E2 drop down menu should adjust dynamically as more Agency names are added to column A.
2. Drop down menu (G2) to list only distinct values from "Sites" column AND dependent on E2 selection. So if "Kepler Specialist" selected in E2, only "Daufny Day Program" and "Art and Foods" should be listed in drop down. Of course blanks should be ignored....
thanks
Sheet1
G2=SORT(FILTER(B2:B100,(A2:A100=E2)*(B2:B100<>"")))
Awesome.....Thanks for fast answer Caracalla. How can I make first list dynamic so it adjusts as I add new data to it? I thought I could by creating a table but I can not reference the table in data validation.
The data validation updates automatically if you add or remove data to the table.
Sorry for my English
Last edited by CARACALLA; 07-02-2021 at 12:17 PM.
Please make your thread titles more detailed. Using the same title every time makes it look like duplicate threads: describe what you spare trying to do in the title each time.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks Caracalla
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks