![]() |
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 |
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