Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formula returns blank in the cell where it is entered
Hello. Has anyone had the problem where an array formula appears blank
within the cell? For example, I have the following array formula in cell G8: =INDEX(H8:AF8,MATCH(TRUE, H8:AF8<0,0)) I am trying to find the first value within a row of blank cells and only a few non-blank cells. After entering the formual and hitting CTRL-SHIFT-ENTER to activate the array, the cell is blank. Clicking the cell shows the formula in the address bar, but there is no result. The cell appears blank when not active. This exact formula works in another spreadsheet, but obviously is not working in my current spreadsheet. The only difference is that the working spreadsheet was created in an older version of excel and the current spreadsheet is in v2003. Thanks. -Steve ps - the following is the working formula from another spreadsheet. =INDEX(B13:AK13, MATCH(TRUE, B13:AK13<0,0)) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formula returns blank in the cell where it is entered
There could be whitespaces within the range H8:AF8
Perhaps try it with a TRIM as (array-entered): =INDEX(H8:AF8,MATCH(TRUE,TRIM(H8:AF8)<"",0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- " wrote: Hello. Has anyone had the problem where an array formula appears blank within the cell? For example, I have the following array formula in cell G8: =INDEX(H8:AF8,MATCH(TRUE, H8:AF8<0,0)) I am trying to find the first value within a row of blank cells and only a few non-blank cells. After entering the formual and hitting CTRL-SHIFT-ENTER to activate the array, the cell is blank. Clicking the cell shows the formula in the address bar, but there is no result. The cell appears blank when not active. This exact formula works in another spreadsheet, but obviously is not working in my current spreadsheet. The only difference is that the working spreadsheet was created in an older version of excel and the current spreadsheet is in v2003. Thanks. -Steve ps - the following is the working formula from another spreadsheet. =INDEX(B13:AK13, MATCH(TRUE, B13:AK13<0,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions |