Trying to make it easy for client to navigate long dropdowns in excel.

I have a list of options in excel (1000 options) which feeds into dropdown choices per row (multiple rows) - this is needed for data validation

This will be given to client to fill...
1000 is too long too scroll through... but also need to protect and validate the choices...

Is there excel functionality to search through the drop down list or something similar to make it manageable for the client to complete?

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

Use vba- https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html

like

Btw the link above adds VBA to an inserted combo box (with dropdown)

Is there a similar method for a regular cell (with drop-down data validation)

Pivot table with filters? Using filter drop downs on a large data set sounds like a nightmare

like

VBA is the best bet.

Depending on how complex the filtering is, you may be able to skate by using the new excel filter function with a spill range, then using offset() in the drop down input window to pick up the variable length list

like

Thanks all!

It's not so much about pre filtering the list it's more about navigating the 1K long list. All options are options and will remain so (they can even choose the same value across rows so nothing gets remkved).

Alternatively rephrasing the question:

- Imagine I have a 1K list of options
- I have 100 cells which the client must populate based on these options
- we need to ensure the client chooses only from these options and inputs match exactly (data validation)
- want to make this process easily navigable for the client

Current approach uses drop-down list but scrolling through 1K options to choose the correct one isn't very manageable

One approach is just to tell them to copy paste from the list on a different sheet... but we're hesitant to trust them to do this correctly and then needing to redo the exercise. Any workarounds to help solve.

Assume client isn't extremely disciplined or technically savvy

I export and import to Google Sheets a lot for the specific reason of collaborating with less technical co-workers. If gsuite is an option for you, their data validation autocompletes and narrows the list as they begin typing in the cell.

Unfortunately not an option but thank you!

Following. I need to do something very similar as well.

Are there screening drop downs you can use to potentially narrow down the needed drop down lists? For example, instead of having a list of a high volume of cities and states, you can break this out and create dynamic drop down lists. In this case, column 1 would include a drop down list to select a state while column 2 will only show the cities tagged to that state. This can be done through a conjunction of names ranges and lookup formulas

Related Posts

Today I drop mail to my project manager to release or change my project related to my primary skill which I Linux system admin.
My manager is agree to release me but my project manager told me atleast wait for quater while they will decide let you know if there is any suitable opening that is mutually beneficial.. 😂

can someone hcl employee pull me in any Linux project .
My main motive is learning Linux azure AWS am certified as well .

like

How is the KPMG client in wipro? Anyone working for KPMG in Wipro? TIA Wipro KPMG

like

Fishes! Currently, I am a Procurement ACon( tech implementation) but I have been put into reporting work ever since I joined the firm in November :(
It's all MS Excel and PPTs.... Though in Excel, I learnt learnt about Power Query, power pivots and intermediate excel formulas...
I am extremely scared about my future :(
Is MS Excel a good to have skill for tech Consulting?
Or how can I ask for roll off from my current project?

like

Dear All,

Hope everything is going good.

Had a question on the below
1. What is CTC for 12years project management roles in sapient
2. Do they have wfh
3. How is the overall culture and flexibility

I have my final round and your inputs will help greatly.

like
like

Anyone hiring in Atlanta for a project/program manager with 8YOE?
Haven't had any success looking via LinkedIn for jobs.
Currently in NYC and want to relocate my family to Atlanta.

like

What was your most interesting project experience? Keep client details confidential.

like

ECD: we need edgy groundbreaking ideas
AD & Me: *works for two weeks on edgy ideas”
ECD & Account: *picks only safe ideas*
Client: these are nice but we want edgy ideas
ECD to us: I need edgy ideas

likefunnyupliftingsmart

Hi All,

Any idea or experience about Nomura project in Capgemini? Is it good to join that project?

like
like

Hi all I'm looking for a referral to work for Thermo Fisher as a Project Manager. I have 13 years experience. Is there anyone who could help me out?

Who is hiring atm? Would love some insight on how to transition into tech/consulting. 8+ YOE in Mgmt: TA, People Ops, Project/ProgramMgmt and I’m ready for a new challenge remote pref.

like

Hi Folks,
I joined capgemini last week and got a call to report at office on next thursday ans friday. Did anyone get a similar call? Also is it mandatory that we have to work in office every 2 days in a week. Please note that I am not allocated to any project.

Can anyone reply.

like

Partners or whomever can help me understand about billing and hours. To keep things simple, let’s say you only have one staff to work 1,700 billable hours a year on a $60k salary and you have only one job that and the rate charged to the client is $300/hour and an projected hours budget of 1,700 hours. So ideally you would have revenue of $510k. If the staff takes less time partners make less money and if they take more time partners make more money while the staff keeps the same salary?

like

What are you doing in replacement of client events?

like
like

I was working for ad agency here in Minneapolis and they reached out to me on LinkedIn without a job description saying that they wanted a seasoned digital project manager which I am. I accepted the offer and started working for this agency and now 6 months in they are asking me also do Wireframes and Content planning together with a project manager role as their team is super small and they do not have dedicated ux/ui and seo members in place.I said that is not my part of the job and parted.

like

Hello fello fishes,

I'm looking forward to a change in either Big4 or in MBBs in Delhi. I'm currently on a project outside Delhi and wishes to relocate back. Could somebody help me with vacancy and referral? Much thanks in advance! :)

Hi All, I have joined LTI 2 years back and working in same project since. I had discussion with my lead that I want to explore opportunities in other projects.
My leads said my tagging is done on current project for total 5 years so I can't leave this project.
My current project don't have any challenging work or growth.
Can I connect with HR directly?

like

Hello fishes, I joined Nagarro on 24th of August. But still no project is assigned yet. Basically I am on bench. Now I am about to get an offer from ServiceNow. I really wanna join ServiceNow as it's a big product based organisation and the competition is really high compared to Nagarro. ServiceNow is giving me a joining date of 1st October. As I am still on bench, will I get released by Nagarro soon ? Because no project is allocated to me.

ServiceNow Nagarro

like

More Posts

like

Has anyone tried for NIW for EB2? Being a Consultant what can be considered as NIW? Having done a fashion designing course or acting course count? Or is it of no use?

like

22 yrs experience and a new grad is being hired for $3 more than I make. I am doing double work because of short staffed. How do I get a raise without letting them know I know the difference?? I am due for my review soon. Thx

likehelpful

So many folks are olaying god of war and im still here downloading skyrim mods

likefunny

Anyone buying ? Got 7k in pocket from previous profits.

like

Thoughts and/or recommendations on career coaches? Im feeling like I need some help narrowing down what direction I should focus on with my career.

like

https://www.adorama.com/iomem10m3bk.html

Anyone having experience with Olympus camera ?

Is there any mt program/new graduate program in google?

like

Dallas Payroll Tax opening! Please let me know if you’d like more info!

like
like

Is anyone thinking about jumping from agencies and heading to an analytics position in another industry like Finance?

like

Flashback to my niece’s birthday. Someone was dressed as her favorite Paw Patrol character

Post Photo
like

male fishies: where do you guys buy your ties?

like

Any recruiting firm/specific contact with a good client book in finance (London)?

like

Which is better to join EY or Amadeus?

like

I had a miscarriage on Tuesday, my first. I didn’t even know I was pregnant. The Dr. was just as baffled by the timing, but here I am. My head is trying to be practical, but my hormones are raging. I feel like a stranger in my own body. How do women do this and work at the same time? I’m a freelancer, I’m so busy at work, I don’t feel comfortable talking to my coworkers about this. I’m trying to just get through the week but am really struggling.

like

Which is best in terms of job security HCL or Accenture?

like

Any insights into Lewis Brisbois? Interview later this week. I haven’t heard great things but wanted to crowd source for more data. TIA.

like

End of Quarter - COVID edition. How has everyone done this quarter? Any adjustments or quota relief?

I am hoping to make a shift to product marketing coming from a non-pmm background. Any recommendation for resume format?

like

Additional Posts in Excel Genius

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

What are the most typical models you all build

likehelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Hey, tips for where to look for good excel cheat sheets online? :)

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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