ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Eliminate double entries in datalist in bulk (https://www.excelbanter.com/excel-discussion-misc-queries/162431-eliminate-double-entries-datalist-bulk.html)

[email protected]

Eliminate double entries in datalist in bulk
 
Hi Excel Professionals,

Got a list of data for several months where I have some double
datasets for example in Jan and Feb and March. It's invoice info. The
only difference between the Jan, Feb and March dataset is the month -
every other info is the same in both months Now, I only need the Jan
record but can not delete datasets according to the month info
datasets only appear once so only in Jan then never again.

Anymethod where I can delete datasets in bulk according to a criteria
made up (invoice number)?

Regards

Marius



All times are GMT +1. The time now is 04:12 AM.

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