Last Data Entered Reference

  • I'm trying to reference the bottom-most non-blank cell in a column (or a range of cells). Any ideas?


    Picture this: 52 rows for 52 weeks. I enter data into the corresponding row once a week. I need to automatically reference the latest data entered into certain columns spanning the week's (row) information. I need to reference the lowest cell in a column that has data in it.


    Thanks,
    SomewhereNorth

  • If all rows are filled in from 1 to the row representing the current week and there is no data below the current week and you want the last value for column B, the this should work:


    =OFFSET(B1,COUNT(B:B)-1,0)


    If my assumptions are wrong, this formula can usually be adjusted to handle them. Post back if this seems to be going in the right direction but is incomplete and I'll try to help.

  • Hi,


    if the data in col.B rows 2 to 53 with heading in row 1


    =INDEX(B2:B53,MAX(IF(B2:B53<>"",ROW(B2:B53))-1),1)
    holding down Ctrl+Shift keys and press Enter to get out of the formula bar


    will return the value in the "bottom-most non-blank cell" within the range.


    jindon

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!