Editing excel is fast and simple using DocHub. Skip installing software to your laptop or computer and make changes using our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and deliver records for completion to other people. All of this, combined with a competing price, makes DocHub the ideal choice to black out stuff in excel files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your records, as we securely keep them in the DocHub cloud.
Todayamp;#39;s topic is to extract unique values from a list of data, and weamp;#39;re going to do this with formulas. (upbeat music) In the first section of the video, Iamp;#39;m going to show you how you can create a list of unique items. And in the second part of the video Iamp;#39;m going to show you how you can create a dynamic drop-down list that only shows these unique items. Now in my quest to find the proper formula for this, I came across simpler versions that required CSE, so Control + Shift + Enter, but I really wanted to come up with a formula that didnamp;#39;t require CSE, this is what I came up with. Here I have a table with the different divisions and the apps that belong to the division, my aim is to get a unique list of divisions here. And later based on this unique list Iamp;#39;m going to create a dynamic drop-down that references this list. And I want this to be totally dynamic, so the moment I add another division within here this gets updated, the drop-dow