When you need to apply a small tweak to the document, it must not take long to Group dropdown voucher. This type of basic action does not have to demand extra education or running through guides to learn it. Using the proper document modifying resource, you will not take more time than is necessary for such a quick edit. Use DocHub to streamline your modifying process whether you are a skilled user or if it is the first time making use of a web-based editor service. This instrument will require minutes or so to learn to Group dropdown voucher. The only thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the amount of time you need to devote to document modifying irrespective of your prior experience with this kind of tools. Make an account now and enhance your efficiency instantly with DocHub!
hello and welcome to the video by Trump Excel I am so mad bun cell and in this video I will show you how to extract data or filter data based on a drop-down list selection in Excel so here I have a dummy data set with the product name in column B sales rep name in column C and country name in column D I also have a drop-down list here in I - with unique country name so there are eight unique country names from this list and the idea is that as soon as I select a country the record for that country should get extracted here in this list so let me show you as soon as I select India all the records for India get extracted here so I have product 1 then I have product 5 then product 8 product 13 and product 20 and when I change the country this latest changes accordingly so I now only have the records for China now you may think that I can do this this thing by applying a filter on this data set but applying filter has two drawbacks first is that I would have to play with the original data