I have a Customer name column and a verified name column. I need to display
all the customer names that are not verified deals. I also need to seperate
the deals into which F&I manager was involved. I am representing the 3
different managers with the numbers 1, 2 and 3.

I am entering "yes" under verification for verified deals and nothing for
pending deals.

Not sure if I'm going to need a macro or? All help is appreciated. Thanks!