Filter duplicate data in a column

[Guest]

I have a spreadsheet (Excel XP) with numerous columns and 65,000 rows of
data. I need to filter the data, preferably hiding, rather than deleting,
any duplicate data that appears in one column. This will result in the rows
of data reducing dramatically.

If I can't hide the duplicate data, is it possible to copy the data, without
duplicates, to a new sheet within the workbook?

 

[Debra Dalgleish]

You can use an Advanced Filter to show the unique items in place, or on
a new sheet. There are instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html

In the criteria area, leave the heading cell empty, and in the cell
below, enter a formula that refers to the column with duplicate data.
For example, if the data are in column C, with the headings in row 1:

=COUNTIF($C$1:C2,C2)=1