Allow data Input but don't allow Edit
Seeking for some help again with these formulas. Have been working on project where multiple people are on the same excel sheet with scanners inputting data. The issues I'm running into is when people aren't paying attention and scan over existing data the information gets overwritten, we lose all that info. I currently have their scans matching another list of info (duplicate) it will go a certain color depending on its category. With that being said I was wondering if there is something I can setup to not allow any more changes if the info inputted was a match with another cell. This is an example of the info I use: So, if another person comes and scans radio 456 into the cell that has 789 instead of picking another blank. Now I will only 1 radio fully charge (456) instead of having both 789/456. Please let me know if this is possible.
Formula challenge: re-shape and cleanup
You're tasked with re-shaping and cleaning up the fictional Faber College alumni list to be used for a mail merge. Going from this: To this: To spice things up, the First and Last names must be in separate columns. Additionally, bellman records must not be included in your list (They've been contacted already). The rules are simple: The solution must be a formula. VBA, PowerQuery, helper columns, fill handle - not allowed. I've included my solution. I believe the best solutions for this exercise will involve some of the newest functions currently available on the Beta channel. I'm looking forward to seeing some creativity. Have at it!Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Add-in Excel Labs
Da tempo sto utilizzando l'add-in Excel Labs, soprattutto nelle sua funzionalità base di "Advanced formula environment" particolarmente utile nella compilazione di formule LAMBDA che stanno avendo un così grande sviluppo in questi ultimi tempi. La facilità nella redazione e nel debug inline delle formule, i commenti e la gestione delle stesse in "Gestione Nomi" ne ha fatto per me e penso per molti uno strumento eccellente che ovviamente non può essere paragonato all'edito base di Excel. Rivolgo perciò un invito a considerare possibile la sua implementazione direttamente in Excel come strumento alternativo all'editor di base . Ritengo che tutti potranno giovarne.
