Hi Folks -

I have a workbook that I"m trying to determine the last row of another sheet (Results!). Right now, I have the formula using 30000 to buy me some time but I'd really love if I could make the formula dynamic to be able to tell me the last row.

Here is my formula:
=IF(AND('Cover Page'!$C$6<>"",TODAY()>C$5),IFERROR(INDEX(Results!$H:$H,AGGREGATE(15,6,ROW(Results!$H$2:$H$30000)/((Results!$M$2:$M$30000='Cover Page'!$C$6)*ISNUMBER(MATCH(Results!$F$2:$F$30000,INDEX($C$5:$G$5,0),0))*ISNA(MATCH(Results!$H$2:$H$30000,$B$5:$B5,0))),1)),""),"")
I tried to use CountA but just returns the column on the current sheet. Is this possible?