how do I shred repeating fields in an excel table?

  • Thread starter Thread starter GHASSAN
  • Start date Start date
G

GHASSAN

basically this is it...
I have a set of data in 3 columns and around 3500 rows.
many of the rows repeat the exact same information. I want to know how to
eliminate repetitions so that I am left with unique data rows?
 
Dear

1. Select all the rows, including the column headers, in the list
2. Click the top left cell of the range and then drag to the bottom right
cell
3. On the Data menu, point to Filter and then click Advanced Filter
4. In the Advanced Filter dialog box click Filter the list
5. Select the Unique records only check box and then click OK

If this post helps click Yes
 
Back
Top