Many times there are instances when you’ll have a large amount of data and you’ll want to be able to extract a listing of one specific column with only one line for each item type.
For example, you may have a listing of all 2,500 customer addresses with a country field and may want to know the full list of countries represented by the customers in the listing.
Here’s a quick and easy method I use to extract the information (and this method is also a small introduction into using logical formulas, which will likely be the next video).
Using an IF function and some sorting, you can extract a listing of information without the duplicate values.
Here’s a screenshot with instructions for how to do it (click here for enlarged version):
Bonus HW assignment: Try to think of other ways that you may be able to get a similar listing without using my method above.