Removing duplicated values in a column

[t2true]

In a spreadsheet, I have a column of account numbers - D1-D3757. Some account numbers are listed multiple times. In, fact, of the 3000+ rows, there are probably only 400 account numbers. I only need the account number listed once in the column. Is there a way to remove all the ones I do not need without selecting each one and deleting them?

Thanks
Ted

[carsto]

do an advanced filter and copy Unique Records to a New Location

[t2true]

Thanks, but I'm not sure how to do that.

[oldchippy]

Hi,

Select the column or click a cell in the range or list you want to filter.
Go to Data > Filter, and then click Advanced Filter.

Click Copy to another location, in the Copy To box, enter a cell reference.

Select the Unique records only check box.

Once you filter for unique values, you can copy them to another worksheet and then archive or delete the original worksheet.

[t2true]

Very Nice. Thank you