Forum Discussion
Removing duplicate numbers from a column.
I have a spreadsheet where I want to remove the duplicate numbers in the column shown below, along with the corresponding info contained in the entire row.
For example, I only want to keep one occurrence of number 902015316 etc. along with the other info in the row and delete the rest of the duplicated info.
| 902015316 |
| 902015316 |
| 902015316 |
| 990499269 |
| 990499269 |
| 990499269 |
| 990499320 |
| 990499320 |
| 990499320 |
| 990499320 |
| 990499320 |
| 990499320 |
Click anywhere in the data.
On the Data tab of the ribbon, in the Data Too,s group, click Remove Duplicates.
Make sure that only the relevant column is selected, then click OK.
Result:
- Hans - thank you very much! That solution worked.
