| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if then statement to return text from cells satisfying condition
HI, I need to check the contents of 29 columns and return the text
values of all the non-zero cells in that row.I am trying to run an if- then statement to acheive the following: if (B1:AD1 1, (return the text within the cells as multiple strings separated by commas),0) I need help on how to acheive this result. I tried concatenation but it wasn't working out. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Filtered cells with satisfying toomany arguments.. | Excel Worksheet Functions | |||
| return multiple cells meeting a condition | Excel Worksheet Functions | |||
| Satisfying 2 conditions and lookup from a 3rd column to return a v | Excel Worksheet Functions | |||
| Multiple Condition Text Return | Excel Worksheet Functions | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
Threaded Mode
