While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should be
linked with D28.

When you say "linked", I am assuming you mean you want the value in the cell
and not the row number. Put this formula in D28...

=LOOKUP(2,1/(C5:C25<""),C5:C25)

--
Rick (MVP - Excel)


"Ahmed Khan" wrote in message
...
While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should
be
linked with D28.

On Fri, 13 Feb 2009 23:40:00 -0800, Ahmed Khan
wrote:

While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should be
linked with D28.


Here is one way you can try.
In cell D28 put the following formula:

=INDEX(C5:C25,MAX((ROW(C5:C25)-ROW(C5)+1)*(C5:C25<"")))

Note: This is an array formula that should be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER.

The result in cell D28 will be the content of the lowest non blank
cell in the range C5:C25.

Hope this helps / Lars-Åke

Here I suggest you a solution with macro
1.Right click on toolbar check the control box
2.Add a command button to your sheet
3.Double click the button to open code window and paste following codes
#

Private Sub CommandButton1_Click()
Dim row As Integer, col As Integer
row = 5
col = 3

Dim lastval As String
lastval = ""
For row = 5 To 25
If Sheet1.Cells(row, col).Value < "" Then
lastval = Sheet1.Cells(row, col).Value
End If

Next

Sheet1.Cells(28, 4).Value = lastval 'link with D28

End Sub
#
Hope this works

Have a nice time

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com

Hi,

Assuming that the cells are going to be empty or contain numbers then

=LOOKUP(9^9,C5:C25)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Ahmed Khan" wrote:

While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should be
linked with D28.

Might want to change that to 99^99 to ensure that number is not in the
range.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 08:45:01 -0800, Shane Devenshire
wrote:

Hi,

Assuming that the cells are going to be empty or contain numbers then

=LOOKUP(9^9,C5:C25)

Try this:

=LOOKUP(1E100,C5:C25)

That will return the *last* numeric value in the range.

--
Biff
Microsoft Excel MVP


"Ahmed Khan" wrote in message
...
While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should
be
linked with D28.

Just to clarify... this formula will return the last entry in the specified
range... whether that entry is a number, date, text, etc. (although it
ignores errors in cells).

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
When you say "linked", I am assuming you mean you want the value in the
cell and not the row number. Put this formula in D28...

=LOOKUP(2,1/(C5:C25<""),C5:C25)

--
Rick (MVP - Excel)


"Ahmed Khan" wrote in message
...
While working on Excel 2007, suppose I am putting some figures in a
particular colum (for instance from C5 to C25), how can I link the lowest
cell in the column to another cell in D28. For example.

C5 has 125
C6 has 148
C7 has 107
C8 has 175

In the above instance cell, C8 is the "lowest" or "last" cell. It should
be
linked with D28.