how do I shred repeating fields in an excel table?
 

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?

how do I shred repeating fields in an excel table?
 

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
--------------
Jacob Skaria


"GHASSAN" wrote:

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?