| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DELETING LINES THAT ARE THE SAME IN A TABLE
I HAVE A PRETTY LARGE LIST OF PRODUCTS AND I WOULD LIKE TO DELETE ANY OF THE
LINES THAT ARE REPEATED. Sorry for the caps. Oh, the lines are not comepletely the same Item number Description EST Cases Weight are the subjects for each line if the item number is the same as another item number I want to delete the whole line |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DELETING LINES THAT ARE THE SAME IN A TABLE
Chip Pearson has lots of techniques for working with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx conditional format if cell contains word wrote: I HAVE A PRETTY LARGE LIST OF PRODUCTS AND I WOULD LIKE TO DELETE ANY OF THE LINES THAT ARE REPEATED. Sorry for the caps. Oh, the lines are not comepletely the same Item number Description EST Cases Weight are the subjects for each line if the item number is the same as another item number I want to delete the whole line -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting lines that use them for formulas | Excel Discussion (Misc queries) | |||
| Removing (deleting, filtering) lines in a pattern . . . | Excel Discussion (Misc queries) | |||
| Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
| Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
| Deleting multiple lines | Excel Discussion (Misc queries) | |||
![conditional format if cell contains word[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
