F
fish
This might take a while to explain: I am not all that familiar with
excel.
In column A have a number (representing an area- from 1-14). In column
D, I have the time. In column E, I have a code. I want to find out how
many times any code is found with another code in the same area in the
space of 5-10 minutes (=>5 mins, =<10 mins). There can only be a
maximum of two codes in an area at one time. If two codes are found in
that time range, then I want to concatenate the codes.
I previously did this in column F for =<5 mins (which is 0.00347222222
expressed in days).
in column F I typed:
=IF(AND(D3-D2<=0.00347222222,A2=A3,E2<>E3),IF(E2<E3,CONCATENATE(E2,E3),CONCATENATE(E3,E2)),)
This worked fine!
For between =>5 mins and =<10 mins (expressed in days) I typed:
=IF(AND(D3-D2>=0.00347222222,<=0.00694444444,A2=A3,E2<>E3),IF(E2<E3,CONCATENATE(E2,E3),CONCATENATE(E3,E2)),)
It doesn't work! Why? What do you suggest?
excel.
In column A have a number (representing an area- from 1-14). In column
D, I have the time. In column E, I have a code. I want to find out how
many times any code is found with another code in the same area in the
space of 5-10 minutes (=>5 mins, =<10 mins). There can only be a
maximum of two codes in an area at one time. If two codes are found in
that time range, then I want to concatenate the codes.
I previously did this in column F for =<5 mins (which is 0.00347222222
expressed in days).
in column F I typed:
=IF(AND(D3-D2<=0.00347222222,A2=A3,E2<>E3),IF(E2<E3,CONCATENATE(E2,E3),CONCATENATE(E3,E2)),)
This worked fine!
For between =>5 mins and =<10 mins (expressed in days) I typed:
=IF(AND(D3-D2>=0.00347222222,<=0.00694444444,A2=A3,E2<>E3),IF(E2<E3,CONCATENATE(E2,E3),CONCATENATE(E3,E2)),)
It doesn't work! Why? What do you suggest?