Last value from column of formulas

[JO505]

I want to return the last posted value from column K. The problem I am having is that the column is populated from the formula show below and all I get is a blank value.

Please Login or Register  to view this content.

It is a column that returns a win loss record based on a given year (column D).

Jim O

[AlKey]

Try these

if you need to return text in column K

=LOOKUP(REPT("z",255),K:K)

If it is numerical

=LOOKUP(10^308,K:K)

[JO505]

The first formula returns a blank cell and the second returns a #N/A, The listed values in the column are displayed as "1-0, or 28-30" or some variation of that, a win-loss record.

Their are blank cell (with only the formula in them) copied down the column. I suspect that has something to do with my problem but I don't know how to work around it.

Jim O

[AlKey]

Can you upload a spreadsheet?

[JO505]

Here is a sample. I did not include all of the formula, just in column K:K. Looking for the last value to be displayed in cell B2.

Jim O

[FDibbins]

Perhaps this?
=INDEX($K$3:$K$333,MATCH("",$K$3:$K$333,0)-1)

[AlKey]

Try this one

=LOOKUP("zzzzz",INDIRECT("K3:K"&COUNTIF(K:K,"?*")+1))

[JO505]

Thank you both for the input. Both formulas work as expected.

Thanks again,
Jim O