remove all duplicates, but keep only unique

[TheTrooper1]

Hi All,

Any idea how to remove all data in a column that is duplicated and only keep the data in a column that does not have a pair or more?

Thanks in advance

[nigelbloomy]

Select the column or row where you want to remove duplicates. Go to the data tab, select remove duplicates, select if your data has headers or not and then hit OK.

[TheTrooper1]

Yeah that will keep just the unique ones. However, anything that has been dupplicated I'd like to remove. ei. remove any pairs. Keep those not duplicated.

Hope that makes sense