Save Similar Dropdown with airSlate SignNow

Import data, Add drop down fields and Sign

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 but in this case my original data gets intact remains intact and the second is that if in this case when I filter these data set in a separate location my cell reference is continuous so I have China in m4 and m5 and now if I change this to India I would have India in m4 m5 m6 m7 and m8 while in this case India would always be in d4 even if I apply a filter these reference would not be continuous which means that I cannot use this data if I'm feeding this in a chart while I can use this to make dynamic charts or formulas so now let me show you how I have done this I have in this another filled another sheet I have the same data set and I'll show you how I created it but first to create that filter I need a list a drop-down list so to create that let me select this entire data set and try and get the unique countries so I selected and I pasted it here to get a unique list go to data and in room here you have this option remove duplicates click on this this opens the room the remove duplicates dialog box and it gives you a list of columns here I only have one which is column D so it's already selected so I click OK and this removes all the duplicate duplicates values and I only have 8 unique values or eight unique countries here now I can go here to i2 and create a data validation drop-down list I go to data and in data I have radar validation in the data validation dialog box within settings you go to this...