Duplicate Rows Merged based on Status

Hi All:

I'm hoping to get pointed in the right direction, but may be wishing for the moon. Attached is a sample...I've deleted some columns not relavent to this. Each person in the table is identified by a Member Code, but can be listed multiple times, with different statuses. I'd like to keep the row with the most info (dates, typically) and change the status following sort of hieracrchy.

So, if a member Opted out, then that is the status of the row...If they renewed, and don't have a row with Opted out, then "Renewed is the status. If they have a row with Due to Renew and Renewed, then Renewed should be the status. Other rows can be removed. Hope this make sense and thanks for any guidance.

hi willhh3,
test.
Note: "1269-USR-03-P285F" is the same as "421345-CM-02-P413B", but the status is different in your output table. Why?
m.s

Good catch. The data comes 3 different reports that are merged into one table. Unfortunately, sometimes the data will overlap, meaning they may show in the Due to Renew report and the Opted Out report. It's ridicules, but this is the data I have and no control over the source. So the short answer is i type-o'd the output as I was trying to show all of the statuses.

I think I've figured out some work arounds (Still tinkering), so if this is too complex don't waste your time. I figured it was a long shot. However if you do have a solution, I'd love to see it to further my knowledge. Thx!

Have you tested the attached file? Did you click the "output" button?
Is the output correct? If not, what should it be like?
The code itself doesn't have to be complicated if clear conditions are defined.
m.s.

Sorry, in my haste I didn't realize there was a sample with the code. I just looked at it and tested it against my sample data. Looks like it does the job! Technically, it's a little beyond my expertise, so I'm going to study it and step through it to gain understand. Marking as Solved and greatly appreciate the learning and follow-up.