Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok, so here's the rundown...
2 seperate databases (and by db's I mean spreadsheets)... one dB has the information for the start time/end time/date/location of medical staff(nationwide). The second dB is a nation wide index of all of the accidents that lists time/location/date and other remarks. What I am looking to do is make 1 cell(on the accident dB) that references the medical staff dB and tells me if the accident occured between the hours that a medical staffer was on duty. A simple Yes or No is all that I'm looking for, but it's gotta match the date, city, and reference between the work hours. The staff dB is expected to be around 3000 lines and the accident db around 5000. Please Help me!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum based on multiple criteria | Excel Worksheet Functions | |||
Counting based on multiple criteria | Excel Discussion (Misc queries) | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |