![]() Column C now contains the same data as in column B but in sorted order. Next place the formula =SMALL(B$6:B$15,A4) in cell C6, highlight the range C6:C15 and press Ctrl-D (to fill down). 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 |