I'd use a Pivot Table. Check here for more information
http://www.cpearson.com/excel/pivots.htm

Regards,
Fred.

"Clay" wrote in message
...
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!