| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula and 2 Tabs!
That's due to a line break issue when you copy n paste from posts. In the
formula bar, just place your cursor on the 2nd line (that's the obvious line break), then remove it by pressing Backspace, then ENTER. All should be ok. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dan the Man" wrote: Hi Max! I copied and pasted both of your suggestions and got a: #REF! error result :(. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needs to include several worksheet tabs in one workbook | Excel Discussion (Misc queries) | |||
| SUMIF formula that crosses multiple sheet tabs | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Deleting some tabs from sum formula | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
Hybrid Mode
