First Occurrence

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

It's either not possible or I didn't explain well enough. Here's a sample
of data with desired output (column C is what I'm trying to calculate).

Col A Col B Col C
1/1/03 00:00 0 0
1/1/03 01:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
 
Mike said:
It's either not possible or I didn't explain well enough. Here's a sample
of data with desired output (column C is what I'm trying to calculate).

Col A Col B Col C
1/1/03 00:00 0 0
1/1/03 01:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
1/1/03 00:00 0 0
Click to expand...
 
Back
Top