ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   DELETING LINES THAT ARE THE SAME IN A TABLE (https://www.excelbanter.com/excel-discussion-misc-queries/232142-deleting-lines-same-table.html)

conditional format if cell contains word[_2_]

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

Dave Peterson

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


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com