PDA

View Full Version : [SOLVED] Counting like cells to determine coverage



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.

Zack Barresse
05-10-2005, 11:03 AM
Hi Austen,

Is this really Solved? I see you marked it such.