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 |