Microsoft Excel- Find The Unique Values In A Column_5495

Microsoft Excel: Find The Unique Values In A Column hp pavilion dv4 battery

See all Microsoft Excel tips


Strategy: There are many solutions to the Unique Customer problem. In this tip, you will use the Advanced Filter command on the data menu. Follow these steps.

1) First Dell Inspiron B130 battery, copy the Customer heading from F1 to a blank area of the spreadsheet gateway laptop batteries, cheap as shown in Fig. 652.

2) Select a single cell in your data range. From the replacement menu, select Data– Filter – Advanced Filter. The Advanced Filter dialog contains shop many powerful options. By default, it will look as shown in Fig. 653.

3) As cheap shown in Fig. 654, choose the Unique Records Only checkbox. Change the Action section to charger Copy to zxcsky09529 Another Location. Selecting this action enables the Copy To range. Place the cursor gateway in the Copy To dialog box and highlight the out-of-the-way copy of the Customer new heading.

4) Choose OK. Excel will find the unique customer numbers and copy them to store the range you specified Dell Inspiron 9400 Battery, as shown in Fig. 655.

Gotcha: Any subsequent use of the compaq Advanced Filter command during this Excel session will remember the List Range specified discount in the prior Advanced Filter.

Summary: One use of the Advanced Filter command acer aspire is to generate a unique list of one particular field in a dataset.

Commands zxcsky09520 Discussed: Data – Advanced Filter


See all Microsoft Excel tips

Im