| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficulty displaying text | Excel Worksheet Functions | |||
| Text not displaying completely | Excel Discussion (Misc queries) | |||
| HELP: text keeps on displaying ############## | Excel Worksheet Functions | |||
| Wrapped text is not displaying in Excel | Excel Discussion (Misc queries) | |||
| Displaying text in vertical | Excel Discussion (Misc queries) | |||
Linear Mode
