Hi everyone, need help coding whether the individual has been there 3 months back to back(jan-mar or feb-apr) for the year. If there are gaps, dont pull include this individuals. Example below: Individual AA is there from jan-mar contionously so we include him, individual BB has gap so dont include him. Could someone provide any ideas which may help Individual Date AA 1/1/2016 AA 2/1/2016 AA 3/1/2016 AA 4/1/2016 AA 7/1/2016 AA 8/1/2016 AA 12/1/2016 BB 2/1/2016 BB 4/1/2016 BB 5/1/2016 BB 7/1/2016 BB 8/1/2016 CC 6/1/2016 CC 7/1/2016 CC 8/1/2016
... View more