help displaying text if certain conditions are met??

[Clay]

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!

 

[Fred Smith]

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

Regards,
Fred.

 

[Joel]

Can you use Sort?

What do you mean by displaying?

 

[Clay]

I need to some how display the customers' names at the bottom of the
worksheet under the title of pending deals. I'm open to any suggestion as to
the best way to do it.

Thanks for the quick reply and please help! lol