mercredi 4 mars 2015

excel - if column against other column

I have two excel sheets. One like below:


Sheet 1:



Column 1 Column 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2
Date 1 Date 2


Sheet 2:



Column 1:
On Time: xx
Not on Time: xx


So example.


If date 1 is greater than date 2, then it should add 1 to the "Not on time" row. And if date 1 is less than or equals date 2, then it should add 1 to the "On Time" row.


Please note that I have two different sheets in the same workbook


How can I achieve this?


Aucun commentaire:

Enregistrer un commentaire