Array formula returns blank in the cell where it is entered


S

stevepejza

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))
 
Ad

Advertisements

G

Guest

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top