Time is a vital resource that every enterprise treasures and attempts to turn into a reward. When picking document management software program, pay attention to a clutterless and user-friendly interface that empowers customers. DocHub offers cutting-edge tools to optimize your file managing and transforms your PDF file editing into a matter of a single click. Hide Dropdown List from the Incorporators' Organizational Meeting with DocHub to save a lot of efforts and increase your productiveness.
Make PDF file editing an simple and easy intuitive process that will save you a lot of precious time. Easily modify your files and deliver them for signing without the need of adopting third-party software. Give attention to relevant tasks and enhance your file managing with DocHub right now.
[Music] im going to show you how to make this reducing length drop down list so that every item that you pick is completely unique no duplicates not only that no vba code at all no macros nothing simple formulas [Music] okay so hows this work right so were clicking on an item so say we click on number two there the next drop down number two no longer in the list if we change that to number three number three number two is back in the list but number three is gone that wont let me pick number two but it will pick number one etcetera so its completely unique and like i said not using any code all the magic is happening in these hidden rows here so let me just unhide those okay so weve got a few formulas generating this so we have our main data validation list here now ive deliberately put this in a crazy order to prove that you dont need to be sorting this in you know alphabetical order or ascending or descending order or anything like that put it in any order your list can be in
