Select the Unique records only check box, and click OK. In the Copy to box, enter a cell reference.Īlternatively, click Collapse Dialog to temporarily hide the dialog box, select a cell on the worksheet, and then press Expand Dialog. On the Data tab, in the Sort & Filter group, click Advanced. ![]() Make sure the range of cells has a column heading. Select the range of cells, or make sure the active cell is in a table. Then you can use the ROWS function to count the number of items in the new range. ![]() You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |