| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combine text under different condition
Hi! I've a question about how to combine text under certain condition.
I would like to generate combine text result in column G given that column A to E are not equal to 0. Column A to E have value of either text or 0. Example: G1 will have the result as ND LCSD, G3 will be TP LCSD...etc. A B C D E F G 0 ND LCSD 0 0 0 0 ND LCSD 0 0 0 TP 0 LCSD 0 0 0 Does anyone knows how to write the formula to generate the result in G? Many thanks!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine more than one condition for CONDITIONAL FORMATTING | Excel Discussion (Misc queries) | |||
| Combine text | Excel Discussion (Misc queries) | |||
| Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
| How can I combine text from several cells into one? | Excel Discussion (Misc queries) | |||
| Combine Two vba Lines(If Condition + Vlookup) | Excel Programming | |||
Threaded Mode
