austenr
05-10-2005, 07:21 AM
O.K. This is a little over my head (well a lot of things are when it comes to this). I have a column of social security numbers that are sorted. There could be and most likely be multiple socials for the same person. I need a way to loop through another column to find what type of coverage they have. Here is the criteria that I need to test for in the other column:
If there is a code of ?Self? then they have self coverage.
If there is a combination of ?Self? and ?Child? and ?Spouse? then they have Family coverage.
If there is a combination of ?Self? and ?Child? then they have Employee plus 1 coverage
If there is a combination of ?Self? and ?Spouse? then they have a coverage type of Employee plus Spouse
I need to have a counter and add to it every time one of the conditions is met.
A test file is attached.
If there is a code of ?Self? then they have self coverage.
If there is a combination of ?Self? and ?Child? and ?Spouse? then they have Family coverage.
If there is a combination of ?Self? and ?Child? then they have Employee plus 1 coverage
If there is a combination of ?Self? and ?Spouse? then they have a coverage type of Employee plus Spouse
I need to have a counter and add to it every time one of the conditions is met.
A test file is attached.