Last active cell in row range...

[Guest]

Hi al
I have a formula that finds the first active cell in a row range and look's up the date in a row above it. This works beautifully. I now need a formula that finds the last active cell in the row range and looks up the date in the row above it

Any suggestions

Find first date formula: {=INDEX($Y$11:$BX$11,,MATCH(TRUE,Y14:BX14<>"",0))
(Row 11 is the date row, row 14 is the activity row, I then copy this formula down all rows on the spreadsheet
Any help greatly appreciated as always
BeSmart

 

[Bob Umlas]

Last active cell in column E:
{=MAX((E1:E5000<>"")*row(1:5000))}
value from row above:
{=INDEX(E:E,MAX((E1:E5000<>"")*row(1:5000))-1)}

Bob Umlas
Excel MVP

(untested formulas)

Hi all
I have a formula that finds the first active cell in a row range and

look's up the date in a row above it. This works beautifully. I now need a
formula that finds the last active cell in the row range and looks up the
date in the row above it.

Any suggestions?

Find first date formula:

(Row 11 is the date row, row 14 is the activity row, I then copy this

formula down all rows on the spreadsheet)