help displaying text if certain conditions are met??
 

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!

help displaying text if certain conditions are met??
 

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!

help displaying text if certain conditions are met??
 

Can you use Sort?

What do you mean by displaying?


"Clay" wrote:

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!

help displaying text if certain conditions are met??
 

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

"Joel" wrote:

Can you use Sort?

What do you mean by displaying?


"Clay" wrote:

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!