| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Repeating Row Fields in a pivot table | Excel Worksheet Functions | |||
| repeating names in row fields of a pivot table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table - Repeating Lables | Excel Worksheet Functions | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
