| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple arrays with If statements
In many ways an alternative to my prior post about ranges with spaces, I'm
hoping this is easier. I want to take a number of If statements, all of which return a text string, "Sample" for example, if true or nothing if not and have them generate a list. I then want to put that list in order into cells on the spreadsheet. So in layman's language (I know it's not VBA...) If A1 = 1 Then Add "Sample" to list If A2 = 5 Then Add "Example" to list Place the list in Cells B1:B2 in the order they appear above. It's so simple when written like that but the adding to list and placing in spreadsheet components defeat me. Advice welcome. Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| If Statements and Arrays | Excel Worksheet Functions | |||
| If Statements and Arrays | Excel Worksheet Functions | |||
| EXCEL ARRAYS & IF STATEMENTS | Excel Worksheet Functions | |||
| Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
Threaded Mode
