Find last filled in cell

  • Thread starter Thread starter Bengt
  • Start date Start date
B

Bengt

Hi,

I need to find the last cell that is filled in with a value.

Cells A1:A6 is the area and the user fill in values from A1 but all cells
are not always filled.
A1: 5
A2: 10
A3: blank
A4: 15
A5: blank
A6: blank
I then want to find A4 easy which means the last cell that is filled in (
or the first if you make a search from cell A6).
The real area I have is 20 cells long so a number og if-functions doesn't
work.

Do you have any suggestions on how to solve this.

Thanks in advance.

/Bengt
 
Hi Bengt!

=LOOKUP(9.99999999999999E+307,1:1)
Returns the last numeric entry in Row 1

=LOOKUP(REPT("z",255),1:1)
Returns the last text entry in Row1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top