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