ExcelBanter - Not sure this is possible

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Not sure this is possible (https://www.excelbanter.com/excel-discussion-misc-queries/74853-not-sure-possible.html)

jason2444

Not sure this is possible

I have large CSV files for automobiles. some of the data in the file are
duplicates with different date ranges. Is there a way to run a search of the
file and and find the ones that match but have a different date rang and
combine them into one
21-6530 WEN Chevy Tahoe - 4 door 1996-04

27-6530 WEN Chevy Tahoe - 4 door 2000-04
27-6530 WEN Chevy Tahoe - 4 door 1996-99

jason2444

Not sure this is possible

Also need to delete the first two

"jason2444" wrote:

I have large CSV files for automobiles. some of the data in the file are
duplicates with different date ranges. Is there a way to run a search of the
file and and find the ones that match but have a different date rang and
combine them into one
21-6530 WEN Chevy Tahoe - 4 door 1996-04

27-6530 WEN Chevy Tahoe - 4 door 2000-04
27-6530 WEN Chevy Tahoe - 4 door 1996-99

All times are GMT +1. The time now is 05:11 PM.