Microsoft Office Tutorials and References
In Depth Information
Finding unique values within a data set
On the Data tab, in the Sort & Filter group, click Advanced to open the Advanced
Filter dialog box.
In the List range field, enter E2:E27 .
Select the Unique records only check box, and then click OK to display the rows that
contain the first occurrence of each different value in the selected range.
TIP Remember that you must include cell E2, the header cell, in the List Range field
so that the filter doesn’t display two occurrences of Northeast in the unique values
list. To test what happens when you don’t include the header cell, try changing the
range in the List Range field to E3:E27, selecting the Unique Records Only check box,
and clicking OK.
On the Data tab, in the Sort & Filter group, click Clear to remove the filter.
In cell H3 , enter the formula =IF(RAND()<0.15,”Yes”,”No”) , and press Enter . A
value of Yes or No appears in cell H3 , depending on the RAND function result.
Select cell H3 , and then drag the ill handle down until it covers cell H27 to copy the
formula into every cell in the range H3:H27 .
With the range H3:H27 still selected, on the Home tab, in the Clipboard group,
click the Copy button. Excel copies the cell range’s contents to the Microsoft Office
Click the Paste arrow, and then in the Paste gallery that appears, click the first icon
in the Paste Values group to replace the cells’ formulas with the formulas’ current