Microsoft Office Tutorials and References
In Depth Information
Finding unique values within a data set
In the List Range field, enter the reference of the cell range you want to examine for unique
values, select the Unique Records Only check box, and then click OK to have Excel display
the row that contains the first occurrence of each value in the column.
IMPORTANT Excel treats the first cell in the data range as a header cell, so it doesn’t consider
the cell as it builds the list of unique values. Be sure to include the header cell in your data
In this exercise, you’ll select random rows from a list of exceptions to identify package
delivery misadventures to investigate, create an AGGREGATE formula to summarize the visible
cells in a filtered worksheet, and find the unique values in one column of data.
SET UP You need the ForFollowUp workbook located in the Chapter05 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Select cells G3:G27 . When you do, the average of the values in the selected cells, the
number of cells selected, and the total of the values in the selected cells appear in the
AutoCalculate area of the status bar.
In cell J2 , enter the formula =AGGREGATE(1,1,G3:G27) . The value $15.76 appears
in cell J2 .