M
Mike
I have dates with hours 1/1/03 0:00 through 23:00 (24 per day) for several
weeks in column
A. Column B has 0 or 1. I want to identify in column C the first occurence
of a 1 with a 1 all other occurences with a 0. Thus in column C for any 24
hour period I would have only one 1.
I've been trying ifs and ands with day function, but still struggling.
Thanks in advance
weeks in column
A. Column B has 0 or 1. I want to identify in column C the first occurence
of a 1 with a 1 all other occurences with a 0. Thus in column C for any 24
hour period I would have only one 1.
I've been trying ifs and ands with day function, but still struggling.
Thanks in advance