I know there is a simple answer to do this, but I am suffering from brain melt right now. I need to compare column E to column G and spit out the records that are different. Example in the table it has the name of a person and in Column E is the plan that we say the person is in and in Column G is the plan that our health insurance provider says they are in. I just then need to spit the whole record out and say E does not equal G.
I wouldn't recommend that route. Insurance is wacky with their names. Eg in some of my dealings we saw: The Builders Group, The Builders Group of MN, Unified Insurance, Unified Insurance Brokers etc etc