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 occu...
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.