Match Dates and Insert Data

[hanif]

Hello,

I have 4 columns of data in one sheet with 2 dates and 2 results (For example col A = date col B = result1, col C = date and col D = result2). cols A and C are different dates with some mutural dates. I would like to search the date columns to find the matching dates and copy the fisrt and second results for that date in another cell next to the dates.

I have attached the file for better understanding.

[Punnam]

Hi hanif,

your requirement is not clear, can you provide example , by just entering the expected results manually

Punnnam

[matklt]

Hi Hanif

This is a duplicate post I have sent you a solution on your original post

Matt

[hanif]

Hi Punnam,

I have explained what I am expecting in the worksheet and updated the attached file. It should be clear now if you look at the attached again.

Hi hanif,

your requirement is not clear, can you provide example , by just entering the expected results manually

Punnnam

[hanif]

Hi Matt,

Thanks for your help, I have replied on the other post. It was perfect, I just need to get rid of the unnecessary cells if you have solution for that.

Hi Hanif

This is a duplicate post I have sent you a solution on your original post

Matt

[matklt]

Hi Hanif

No problem I have had another look and the attached solution will do the filter for you automatically

Regards

Matt

[martindwilson]

other post at
http://www.excelforum.com/excel-prog...ml#post3947146