Related Posts
In BGC, do company gets to know about projects we worked in previous company?? Like :
1. Our duration in project ?
2. How many projects we worked?
3. Project type : support or development? Heard of fake BGC firing... From top MNCs. Accenture Tata Consultancy Wipro Cognizant Infosys HCL Technologies
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
More Posts
Young software engineer here, looking for a (preferably remote) job opportunity. Cut workflow by 50% as Executive Editor, managed end to end creation of several websites as lead web developer for startup, been programming since high school. Recently graduated from college and awarded top graduating CS student by faculty. Anyone able to give me a referral from Apple Microsoft Adobe Google, or know of a job opening with good WLB, benefits and competitive salary? DM me for more info.
male fishies: where do you guys buy your ties?
Which is better to join EY or Amadeus?
Additional Posts in Excel Genius
Google Sheets vs Excel - pros? cons? differences?
What are the most typical models you all build
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?
New to Fishbowl?
unlock all discussions on Fishbowl.
Use vba- https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html
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
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
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