| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine which values are = 0 & create string
Hi all,
I have a list of items & values in two columns.... for example Apple 3 Banana 0 Pear 5 Orange 8 Grapefruit 0 At the bottom of the list, I want to have a cell that will say which values are zero. For example: "You have no bananas, grapefruit" If apple was also = 0 it would say "You have no apples, bananas, grapefruit" Is there a way to do this without VBA code? Is it just going to be a crazy IF statement? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the values? | Excel Discussion (Misc queries) | |||
| How to determine the values? | Excel Worksheet Functions | |||
| determine wheter string has a number in it? | Excel Worksheet Functions | |||
| Create a 'text' string based on whether values appear in other cel | Excel Worksheet Functions | |||
| How do I create a crosstab process to determine patterns in surve. | Excel Worksheet Functions | |||
Threaded Mode
