T
tim
I am having some problems...
What I am trying to do is to use countif like this...
countif(D$5:d5,">b5")
I am working on an incident tracker. The incident has a
beginning and an end. There can be multiple incidents
occurring at a given time. I am trying to determine the
number of incidents at the onset of a new incident. The
problem is the countif function will allow for b5, a
direct comparison or for example >10, a set comparison, I
need to be able to have b5 to change with each incident
here b is the start time and d is the end times
here is an example
incident beginning end number at one time
1175160 21:17:54 21:36:58 1
1175118 21:35:01 21:55:37 2
1175160 21:41:04 21:44:26 2
1175164 21:41:27 21:56:02 3
What I am trying to do is to use countif like this...
countif(D$5:d5,">b5")
I am working on an incident tracker. The incident has a
beginning and an end. There can be multiple incidents
occurring at a given time. I am trying to determine the
number of incidents at the onset of a new incident. The
problem is the countif function will allow for b5, a
direct comparison or for example >10, a set comparison, I
need to be able to have b5 to change with each incident
here b is the start time and d is the end times
here is an example
incident beginning end number at one time
1175160 21:17:54 21:36:58 1
1175118 21:35:01 21:55:37 2
1175160 21:41:04 21:44:26 2
1175164 21:41:27 21:56:02 3