You know you are using the proper document editor when such a basic job as Analyze dropdown notice does not take more time than it should. Editing files is now a part of a lot of working processes in numerous professional fields, which is the reason convenience and simplicity are crucial for editing tools. If you find yourself researching manuals or trying to find tips about how to Analyze dropdown notice, you might want to find a more easy-to-use solution to save time on theoretical learning. And here is where DocHub shines. No training is required. Just open the editor, which will guide you through its main functions and features.
A workflow becomes smoother with DocHub. Use this instrument to complete the paperwork you need in short time and take your productivity to a higher level!
[Music] welcome to Excel magic trick number 1523 hey were still talking about dynamic arrays and we got to talk about data validation list drop-down but we want a unique sorted list in our drop-down with no blanks now weve been looking for a solution like this for years and with the new office 365 dynamic arrays the solution is easy now lets look at the end result I simply want a sorted drop-down that will allow me to change this Im going to change it to Al and enter and when I come over to the drop-down theres al right at the top now well go over to the sheet 1523 now the first thing we want to do is extract from the player column a sorted unique list now Im going to add an empty here because we have to deal with that well in office 365 this is simply amazing Im going to use this sort function and then the unique function now Im going to highlight this range control shift down arrow ctrl backspace close parentheses close parentheses and enter Oh formulas treat empty cells as