Often, it can be challenging to understand large amounts of Excel data from different perspectives. Excel has a number of direct formulas to find solutions for items like the sum of the data or the averages, but it can be difficult to understand how many variations of results, or unique entries, exist in a certain selection of data. For example, if you have 1,000 survey results that include respondents’ favourite dessert but would like to know how many types of desserts were suggested, it would be a cumbersome task to determine the number of unique entries manually. The author in this short Lynda.com video, “Count the number of unique entries,” explains a simple alternative for summarizing the number of unique results within a dataset and provides a few other helpful Excel navigation tips along the way!
Read more at our lynda.ubc.ca site to learn more about this subject and to find associated resources.