Well, I understand that the index formula should have returned 8.50, but
I've reentered the formula and committed it (with CSE) and the value
continues to be 0.

Don

p.s., how here is a thought, could the index formula be returning 0 because
not all cells in the "array" are filled yet? If only, say, 25 cells have
values, that should not cause the result to be 0, should it?


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You said previously "the formula should return 8.50, but it's returning
0", but with those data values & those formulae (remembering that the C1
formula needs to be array-entered), C1 returns 8.5 for me, so I don't know
how you've got zero.
--
David Biddulph

"DW" wrote in message
...
ok.........sorry you weren't able to follow......here's the whole
thing..............

I'm trying to find the first blank cell in a column and then go up one
cell to capture that cell value....I am then using that value in a simple
subtraction. My calculation is thus:

cell B1: =70-C1 cell C1:
=INDEX(A1:A30,MATCH(TRUE,A1:A30="",0)-1,0)

using separate cells just so I can see the formula results

My list is:

6.00
13.83
22.33
22.33
0.00
8.50
17.00
17.00
0.00
8.50
17.00
25.50
33.50
42.00
42.00
0.00
8.50

The list, of course, grows daily.


Don

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You've snipped so much of the context that we can't see what formula you
are trying to use.
--
David Biddulph

"DW" wrote in message
...
Ok, did what you suggested.......but am getting a 0 value....below is
my current list (it of course grows every day), starting in A1. Now,
with A19 being blank, the formula should return 8.50, but it's
returning 0.

6.00
13.83
22.33
22.33
0.00
8.50
17.00
17.00
0.00
8.50
17.00
25.50
33.50
42.00
42.00
0.00
8.50


Don

"Peo Sjoblom" wrote in message
...
It's this part

A1:A10=""

it's what is called an array formula, you can lookup array formula in
help

http://www.cpearson.com/excel/ArrayFormulas.aspx


--


Regards,


Peo Sjoblom



"DW" wrote in message
...
Thanks everyone....

Now, this might be a dumb question, but why the ctrl+shift + enter
combo to commit the formula?


Don