lundi 30 mars 2015

How to compare columns in excel with date

I would like to compare two columns but have conditions with them.


My Data:


Coloumn A Mon, 23 Mar 2015 17:56:40 Mon, 23 Mar 2015 17:57:03 Tue, 24 Mar 2015 08:51:48 Tue, 24 Mar 2015 06:20:57 Tue, 24 Mar 2015 11:42:07 Tue, 24 Mar 2015 11:42:41 Tue, 24 Mar 2015 11:43:11 Tue, 24 Mar 2015 11:40:31 Tue, 24 Mar 2015 11:56:13 Tue, 24 Mar 2015 18:55:38 Wed, 25 Mar 2015 08:45:36 Wed, 25 Mar 2015 12:59:24 Wed, 25 Mar 2015 13:50:26 Wed, 25 Mar 2015 13:58:20



Coloumn B
4802xxxxx
4802XXXXX
4802XXXXX
4802XXXXX
4802XXXXX


I have to 2 sheets that have the same format, and would like to compare the coloumn B(sheet1) with coloumB (sheet2). And make sure the calls came in at the same time. USING the Coloumn A. Compare Coloumn A (sheet1) with ColoumnA (sheet2). All this at the same time.


Aucun commentaire:

Enregistrer un commentaire