Combining singles data records

S

sunman

Hi,

I have the following problem where I can not find a solution for. In my
excel sheet I have the following data: Number, Code, day, month, year, day,
month, year.

What I want is, if the number and the code are the same and the period of
days is following each other, to have only 1 record in the excel sheet.

E.g.
What I have right now
Number Code Day Month year day month year

0012 CP 10 05 2005 10 05 2005
0013 CJ 11 05 2005 11 05 2005
0013 CJ 12 05 2005 12 05 2005
0013 CJ 13 05 2005 13 05 2005
0014 CP 14 06 2005 14 06 2005
0014 CP 15 06 2006 15 06 2005

Result I want to have
0012 CP 10 05 2005 10 05 2005
0013 CJ 11 05 2005 13 05 2005
0014 CP 14 06 2005 14 06 2005

Thx for all the help
Regards
Dries
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Find then highlight in yellow 6
2 dimensional date sort 2
I need to help with Excel (beginner) -- year row and month column 2
Too negative XIRR? 3
Count the highest number of days without “errors” 2
Calculating interest due on late loan payments 1
Formula to count Month in Dates 4

Top