First Occurrence

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
 
M

Mike

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to create charts 1
Pls help for Simple Calculation 1
separating date and time 5
Conditional Time Calculation 10
tiny discrepancies in fixed-point numbers 3
Pivot Table Summarizing Quirk - Please Help 1
help in formula countif OR sumproduct 4
How to match the values? 5

Top