👉

Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Where Form 2220 Select

Instructions and Help about Where Form 2220 Select

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...

If you believe that this page should be taken down, please follow our DMCA take down process here.