You can also use Excel formulas to sort a column of data, as described in the following example.Įxamples 1: Sort the numeric data in column B of Figure 1.įigure 1 – Sorting numeric data using standard Excel formulasĬreate a column of indices in column A by putting 1 in cell A6, the formula =A6+1 in cell A7 and then filling down (by highlighting the range A7:A15 and pressing Ctrl-D). See Sorting and Filtering for more details. These can be accessed by Data > Sort & Filter|Sort and Data > Data Tools|Remove Duplicates. ![]() ![]() ![]() Excel provides standard capabilities for sorting and eliminating duplicates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |