Counting every other cell that matches

 I am trying to count matches between every other cell.  ON my screen shot you can see a date in green followed immediately by a date in red.  If those 2 dates match, that means it was done “SAME DAY”.  If those dates don’t match, then it was done “NOT SAME DAY”.

So i am trying to compile a count of “SAME DAY”s and “NOT SAME DAY”s.

In the screen shot it would be

SAME DAY: 4

NOT SAME DAY: 1

 

By: Mark

One thought on “Counting every other cell that matches

  1. Mark

    I’m sorry. i don’t see the screen shot. Data is:
    Date
    7/6/2017
    7/7/2017

    7/6/2017
    7/7/2017

    7/6/2017
    7/7/2017

    7/6/2017
    7/7/2017

    7/7/2017
    7/7/2017

    * i added a space just between rows just to show that each pair is considered an entry. but on my sheet it is all in consecutive rows.

Leave a Reply

Your email address will not be published. Required fields are marked *