Sort Table#

Overview#

Sort Table is a tool to rearrange data by ascending/descending orders. Sorting would be based on the header row selected by user.

Videos#

Examples#

Here is a step-by-step example of using Sort Table to find the highest math score student.

  1. Prepare an Excel sheet with data to sort.

  2. Open Finplicity, and then click Data Basics > Sort Table. The form of Sort Table will appear, as shown below.

  3. Select the data to sort. In this example, select A1:C12.

  4. Select sorting header and sorting order. In this example, to find the highest math score student, select “math score” as sorting header and check “Sort in Descending Order.”

  5. Select output location. In this example, select E1.

  6. Now you have finished all the required fields in this form, and you can click “Run” to sort table or click “Save” to save this task. The sorted data will automatically be shown in the output location.

    As we can see, the student whose id is 103 has the highest math score 90.

FAQ#

  • Does the data have to include a header row?

Yes, the user must select data with header. If the user simply selects a column of numeric data, the first row would be treated as header row by default.

  • What if the sorting column contains both numerical and nonnumerical values?

For a set of data containing both numerical and nonnumerical data, Sort Table will only sort the numerical data and the nonnumerical data would be placed at the bottom of the current column. The user would need to use Sort Table again to rearrange the nonnumerical data.

On this page