Remove Duplicates#

Overview#

Remove Duplicates is a tool to get rid of repeated redundant values in a dataset.

Videos#

Examples#

Here is a step-by-step example of using Remove Duplicates to filter data. In this example we aim to select the student with the highest math score in each group.

  1. Prepare an Excel sheet with data to filter.

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

  3. Select the data range to manipulate. In this example, select A1:C12. Check “The top row is header” if you have included header row in the data range. We will check it in this example.

  4. Choose reduction columns to be based on. In this example, since we want to keep the student with the highest math score in each group, click “Base on one column” and select “math score.”

  5. Click “Keep the largest of the copies” since we want to keep the highest math score students. If you want to keep the lowest, you need to click “Keep the smallest of the copies.”

  6. Choose an output location. In this example, we will select E1.

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

FAQ#

  • Why is dropdown in “Base on one column” disabled?

If “The top row is header” is unchecked in Step 1, “Base on one column” will be disabled.

  • Among duplicated rows, which row will be kept after removing duplicates?

By default, the first row will be kept. If you want to keep the row with the largest/smallest value in a column, check “Based on one column” and choose your preference.

On this page