I have a large list of names and locations that I need to creat drop down lists for. I need the drop downs to be dependent on another since there are duplicate names. E.g. when I select John Doe, I want the second drop-down to only show San Fransico (John from San Fran) and New York (John from New York). I don’t want the other 500 cities to pop up in that drop down. Vice versa if I select location first, I only want the people in that location to show in the people drop down. Is this possible???

like
Posting as :
works at
You are currently posting as works at

Without VBA (aka simple):
- Possible but have limitations. The idea would be to use a spill function (e.g.: =FILTER()) and use data validation on the range. The limitations would be:
i) You have to have automatic calculations enabled otherwise the output won't change
ii) You have no way to control if =FILTER() output will be 5, 10 or 50000 directly (you can create constrains in the function but not the case)

Remember to check the "ignore blank option" if blank is not an option.

With VBA (aka complicated):
- Possible, but troublesome to build. Constrained by edge cases

like

Like this

Post Photo

You can use a conditional named range to return the values to your drop down list. Worth a google :)

like

VBA is the way to go and isn’t difficult at all with the newest versions of excel. Just make sure you have your developer ribbon enabled in options —> go to developer tab—> click design mode—> insert—> list box
And you have yourself a drop down menu

I would check out
Www.excel-easy.com/VBA/activex-controls.html

like

Related Posts

Hello all, here’s my current 3-watch collection! Looking to get a GMT next to complete the land-sea-air trinity but am also considering a nice dress piece

Post Photo
like

Hello people of San Diego! Would love to hear how y’all are affording to live here comfortably. Please state your company, position, TC, YOE, and do you have a side hustle? I’ll start - I’m an advisor in Wealth Management with TC of $70k, 3 YOE and no side hustle. Among other things, rent just jumped from $2500 to $3700 for 2 bedroom and areas were looking at. I’d like to “make it” here but if it means switching career to make money I’d like to get an idea to make the right job change.

like

What is a good salaray range for sr data analyst in the dfw area?

Any integrated producers looking for a full time job? San Diego based company looking for a integrated producer. Let me know if you’re interested!

like

Let’s get this bowl active and going. What are ATL fishes doing for fun this weekend?

Hey 👋 just joined here and my second post . I started my construction business now for over two years working on residential renovations and looking to make the jump to commercial construction! Looking for a mentor who is knowledgeable of Commercial construction and can help me understand the ins and outs of the industry here in San Diego. Please reach out if you’re in commercial industry and would like to help. Would be greatly appreciated 🙏🏻

like

Just curious are there any EAs in the Las Vegas, NV area and what are your salaries?

like

Any NYC or PHL ad agencies looking for staff or freelance senior or executive producers?

like

How hard is it to unload a lease in CLT? Has anyone done it before?

like

GSP San Fran or Leo Chicago?

like

So how does the Uber PIN thing work at LGA? Whenever I request an UBER there, it just connects me with a driver. I don’t get a PIN for the cars queuing up.

Has anyone changed your project after being selected in Jan. DCA?

like

Oh boy, they just paged “Mary and Joseph” in LGA C....

likefunny

Hello guys, I need good docs/site to learn S4 HANA so that I do not get lost in the sea of material available online . Please post your valuable comments.

A shout-out to the timely, engaging, and relevant work created by Grab in-house for the SEA region. It should be awarded creative advertiser of the year.

Hey, work at Big 4 in San Diego office doing fin services - want to move into something techish related in San Diego. Any thoughts?

like

Seattle vs San Diego?

like

Our district is so lax on the students this year. With tech issues and distance learning days, we’ve gone from accommodating to enabling real quick. No penalties for late work, taking excuses for attendance, lower academic and behavioral standards... We were beginning to make so much progress on transforming our school culture, but this year is erasing that and then some. Is anyone else concerned about how to raise the expectations and students’ self-discipline back to pre-enabling levels?

likesmart

Help me ask for a raise in my upcoming performance review? In sum, my company’s HQ is in Texas and I feel I’m being paid a Texas wage when I live in Los Angeles (the role is remote). We do have a San Francisco office and I want to ask my boss to match me what staff are making there. As that’s more comparable. Based off of Glassdoor, my salary matches Texas’s exactly and SF has the same role at 10k more. Should I show him the Glassdoor page? Don’t want to come off too strong. Please advise

like

More Posts

What's the biggest lie a professor told you at college?
I studied journalism and I had one professor who always talked about how ethic we should be in order to pick the news to write about.
I've been working as a journalist for years and I've never gotten to decide the news by myself lol

like

If someone revoke resignation in TCS.
Is there any rule that he cannot resign for certain period and where can I find that policy???

like

24k miles on my SQ5 and it’s telling me the brake pads needs to be replaced. Is this normal? Aren’t they supposed to last longer than that?

likefunny

Accenture job opportunities in following infra engineering and cybersecurity skills. If interested share resume at helpacenreferral@gmail.com along.
Exp 2-14 yrs
Location PAN India.
Ps. Avoid if already applied or interviewed in last 12 months.

Post Photo
like

Globant or HCL Technologies please suggest , in terms of Salesforce projects , work life balance ,job security ,better policies ?

like

I am a mechanical engineer having 10 years of experience in wind and automotive domain. Is it possible to switch to IT domain. Please suggest some course without or with basic codeing to get some IT jobs.

like

Long shot but wondering what the going salary is for Senior Producers in Toronto?

I’m a producer with six (will be 7 when my current contract is done) years experience in agency production looking to make the transition to Senior Producer and wondering what to settle for/negotiate.

like

Curious to know what would be the base salary range for Project Managers in IT implementations in the Houston, TX area. 14 yrs total IT experience and 5 yrs as a PM.

like

Hi Fishes

Does EY GDS give 10% Variable and EY India give 20% variable?

like

Entry level cloud engineer salary range for ease coast ?

like

Boyfriend and I have been dating for ~1.5 years and we still only spend weekends together. I want to move in together at the 2 year mark but bf thinks it’s too soon... just feels our relationship is stagnant and not going anywhere. Any thoughts from ppl who’ve gone through similar situations?

like

My friend just got out of a relationship and hooked up with his ex's best friend a week later. They're now dating and seeing each other everyday.
I couldn't help but feel like this wasn't an appropriate thing to do for both parties. He also revealed that he cheated on his past exes.

I'm naturally feeling a bit weary of his character and questioning whether this is a friend I want to keep close in my life. Perhaps I'm being too judgmental?

like

Just found out my boyfriend of 3 months (talking stage was about 6 months before making it official) slept with his ex a couple times while we were talking. After we agreed to be exclusive. Without protection. I’m so crushed 😞

like

Been having trouble moving on since girlfriend ended relationship 3 weeks ago after 2+ years of dating. Before ending it she came over 3 weeks prior to basically give me a chance to work things out and we had a good discussion but then I went back into our routine and didn’t really fight for it or have serious follow up convos that we needed. Now I just have so many regrets that I let her go. I know we still love each other and left on “good” terms but can’t forgive myself for my lack of action.

like

Any tips for hard launching partners on social media? For context, I’ve (Indian American female) been dating my white American boyfriend for 3 years and we just got engaged after two years of convincing my parents. They are very happy and excited now, but I’m scared shitless about being ostracized / judged by my extended family and Indian community in the US once I “let the cat out of the bag” on the engagement news. I want to be proud and confident about this but could use some moral support.

like

L&T Infotech is hiring Pan India for below roles: Interested people can drop their email id's and Names with respective Job Id's .

Post Photo
like

Any travel recommendations in December?

like

Anyone at The Clios and want to hire a junior AD? I’m here and hungry.

Favourite money saving hacks? Signed, Broke in New York.

likehelpful

Additional Posts in Excel Genius

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

How long did it take you to become good at excel? Like fast?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Would anyone be willing to teach me vlookup?

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

PowerQuery > PowerBI .. thoughts ?

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Why don't recent grads know how to use excel?

likehelpfulfunny

How do you fix microsoft excel cannot paste data error?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal