I have an excel sheet that tracks contracts, and if a contract is denied, it gives the reason. The reason is normally something along the lines of, "invalid account umber" or "credit denied" but there is over 20,000 rows and the reasons are not uniform in wording. I have a pivot table with the percentages of accounts rejected but need to exclude certain contract denials, such as those which are denied for credit reasons.

Any advice?

Thanks,

Nick