Deleting Duplicate Values in Table

If you want to clear the twin data values in a range of cells or table, then other values outside that range will not change. Given the twin data loss is permanent, it is recommended before deleting it so that you make a copy of the data range at another location within the same worksheet or workbook.

The steps are as follows:

1. Pick a range of cells or table, or at least active cell arriving at the table in question.
2. Through tab Data, the group Data Tools, click Remove Dupliucates.

1. Remove Duplicates dialog will appear. Do as follows:
• In the colums box, select which columns will be selected to be filtered. In the example chosen column numbers and names Members Members to ensure that no twins.
• To select an entire column quickly, click Select All.
• To remove all of the options on the column quickly, click Unselect All.

• After the selection of the dialog box above is completed, click the OK button.
• If it turns out there is no data to twins, then the screen will display a dialog box informing you that No duplicate values found.

• If for example you choose to filter a column group, then when clicked will display a dialog box informing you that there are 42 duplicate data is deleted, and there are 4 unique data remaining. With these steps, you can easily figure out that how many group memberships are stored in this table.

Results of these filters can still be Undo with Ctrl + Z if you do not intend to fix the results.