| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Array with multiple results
I would like to have an array formula that returns the order# contained in
column A if column B has an error in it. Is it also possible to enter this formula into one cell as I don't know how many errors could be in column B. Example A B 123456 S-12-04 123457 #N/A 123458 DS-12-06 123459 #N/A 123460 S-12-05 Array formula would return.... 123457, 123459 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is the bug in my array? | Excel Discussion (Misc queries) | |||
| Working with array equations | Excel Discussion (Misc queries) | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
