How to Extract Data based on a Drop-Down List selection In Microsoft Excel

In this video tutorial, learn how to extract or filter data in Excel based on a drop-down list selection. How to Extract Data based on drop-down list selection in Microsoft excel<br /><br />This Excel trick is extremely useful in situations where you have a huge dataset and you want to extract part of it by making a selection. <br /><br /><br />There are three steps in extracting data based on a drop-down selection:<br />1. Create a Unique list of items.<br />2. Create a drop-down to display these unique items.<br />3. Use helper columns to extract the records for the selected item.<br /><br />Insurance of Cars'_<br />America kingdom_<br />Gold,Diamond"'<br />Expensive Cars__<br />Netflix<br />Linkedin Marketing<br />Digital Marketing_<br />Australian universities_<br />BasketBall Players<br />Earning on binance