How to compare content of two columns

**Klingon** · 11-05-2007, 05:42 AM

I have two colums both with alot of dates in the following format dd.mm.yyyy hh:ss

I want to be able to sort out those that have the same date (doesnt have to be the same time)

There are 1800+ rows so Id rather not do this manually :|

**corinereyes** · 11-05-2007, 06:10 AM

Hi Klingon,

You can use the MATCH or SUMPRODUCT function.

**Klingon** · 11-05-2007, 07:34 AM

Originally Posted by corinereyes

Hi Klingon,

You can use the MATCH or SUMPRODUCT function.

As I am a novice Excel users could you tell me where to find these functions and how to use them for my particular purposes?

Thank you

**corinereyes** · 11-05-2007, 10:13 AM

Hi Klingon,

Kindly see the attached sample xl file. Just give me a feedback if this is what you're looking for.

Hope this helps.

**arthurbr** · 11-05-2007, 10:22 AM

keplah !

You might also want to check this one out :http://www.cpearson.com/excel/ListFunctions.aspx

**bacalhoun** · 02-05-2008, 12:55 PM

I especially found corinereyes reply to be helpful. I needed to compare Hire Date to Service Date and I was able to easily use the example to do this and put in a special message. Now I just need to work out how to record a macro so that outsourcing team can run it every month on new spreadsheet that they run of prior month rehires.