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.
It is a column that returns a win loss record based on a given year (column D).
=IF(AND($G3="",$H3=""),"",COUNTIFS($D$3:$D3,$D3,$I$3:$I3,"W")&" - "&COUNTIFS($D$3:$D3,$D3,$I$3:$I3,"L"))
Jim O
Last edited by JO505; 09-08-2015 at 06:44 PM.
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)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
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
Can you upload a spreadsheet?
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
Perhaps this?
=INDEX($K$3:$K$333,MATCH("",$K$3:$K$333,0)-1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this one
=LOOKUP("zzzzz",INDIRECT("K3:K"&COUNTIF(K:K,"?*")+1))
Thank you both for the input. Both formulas work as expected.
Thanks again,
Jim O
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks