In worksheet 1, column A I have a long list (350K rows) of dates and times
of an event (namely when an ambulance goes enroute to the hospital..)

In worksheet 2 (8K rows) I have data from hospitals with times they are
unable to accept ambulances with column A (start date/time) and column B
(stop date/time)

My goal is this: In a new column (column B, worksheet 1) I need a formula
that creates a flag for every transport in worksheet 1 that occurs during any
time between Columns A and B in worksheet 2.

I can use "if" statements to analyse one row but I can't figure out how to
compare multiple rows...I'm using Excel 2007 for windows.

thanks

Hi,

I'm not clear on you question, with 8000 rows on sheet2 each with a
different time? what are your time increments? 24*60 = 1440. Are you
tracking at the 10 second interval? Also since you have a start and an end
time which interval do you want reflected in sheet1, the start or the end?
Say it starts at 8:01 AM and ends at 11:37 AM (long ride) that would be
about 800 time slots it could fall into.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"daveg" wrote:

In worksheet 1, column A I have a long list (350K rows) of dates and times
of an event (namely when an ambulance goes enroute to the hospital..)

In worksheet 2 (8K rows) I have data from hospitals with times they are
unable to accept ambulances with column A (start date/time) and column B
(stop date/time)

My goal is this: In a new column (column B, worksheet 1) I need a formula
that creates a flag for every transport in worksheet 1 that occurs during any
time between Columns A and B in worksheet 2.

I can use "if" statements to analyse one row but I can't figure out how to
compare multiple rows...I'm using Excel 2007 for windows.

thanks