If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|