Remember Lowest Value in Cell

Remember Lowest Value in Cell

Cell D3 contains a numeric value.

As data is changed in cell D3, I want cell G3 to keep track of the
lowest value that was entered in Cell D3.

How do I do this?

Thanks

date: Sat, 11 Oct 2008 04:57:30 -0700 (PDT) author: iamnu

Re: Remember Lowest Value in Cell

Right click sheet tab>view code>copy/paste this. Put a large value in d3 and 
go from there

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$D$3" Then Exit Sub
lv = Range("g3")
If Target < lv Then Range("g3").Value = Target
End Sub

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"iamnu"  wrote in message 
news:bf927460-e0e8-4901-9e9b-93f56af17783@i18g2000prf.googlegroups.com...
> Cell D3 contains a numeric value.
>
> As data is changed in cell D3, I want cell G3 to keep track of the
> lowest value that was entered in Cell D3.
>
> How do I do this?
>
> Thanks

date: Sat, 11 Oct 2008 08:09:12 -0500 author: Don Guillett

Re: Remember Lowest Value in Cell

On Oct 11, 7:09 am, "Don Guillett"  wrote:
> Right click sheet tab>view code>copy/paste this. Put a large value in d3 and
> go from there
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address <> "$D$3" Then Exit Sub
> lv = Range("g3")
> If Target < lv Then Range("g3").Value = Target
> End Sub
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"iamnu"  wrote in message
>
> news:bf927460-e0e8-4901-9e9b-93f56af17783@i18g2000prf.googlegroups.com...
>
> > Cell D3 contains a numeric value.
>
> > As data is changed in cell D3, I want cell G3 to keep track of the
> > lowest value that was entered in Cell D3.
>
> > How do I do this?
>
> > Thanks

Thank you sir, perfect!

date: Sat, 11 Oct 2008 07:14:14 -0700 (PDT) author: iamnu

Re: Remember Lowest Value in Cell

Glad to help

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"iamnu"  wrote in message 
news:ae210f4c-f541-47d3-ba88-9978639b564b@b30g2000prf.googlegroups.com...
On Oct 11, 7:09 am, "Don Guillett"  wrote:
> Right click sheet tab>view code>copy/paste this. Put a large value in d3 
> and
> go from there
>
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address <> "$D$3" Then Exit Sub
> lv = Range("g3")
> If Target < lv Then Range("g3").Value = Target
> End Sub
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"iamnu"  wrote in message
>
> news:bf927460-e0e8-4901-9e9b-93f56af17783@i18g2000prf.googlegroups.com...
>
> > Cell D3 contains a numeric value.
>
> > As data is changed in cell D3, I want cell G3 to keep track of the
> > lowest value that was entered in Cell D3.
>
> > How do I do this?
>
> > Thanks

Thank you sir, perfect!

date: Sat, 11 Oct 2008 10:03:20 -0500 author: Don Guillett

Re: Remember Lowest Value in Cell

If you want to avoid VBA and do it with a formula, you can use the
following in G3.

=IF(D3="",100,MIN(D3,G3))

This creates a circular reference (a formula referring to itself) so
you'll need to dismiss the "help" that Excel will provide and go to
the Tools menu, choose Options, then Calculation, and check the
Iterations option.

The 100 in the formula is used to initialize the "minimum" value. You
can change it to a value that will be greater than the actual minimum
is expected to be.

Cordially,
Chip Pearson
Microsoft MVP
    Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
The San Diego Project Group, LLC
(email is on the web site)
USA Central Daylight Time (-5:00 GMT)

On Sat, 11 Oct 2008 04:57:30 -0700 (PDT), iamnu 
wrote:

>Cell D3 contains a numeric value.
>
>As data is changed in cell D3, I want cell G3 to keep track of the
>lowest value that was entered in Cell D3.
>
>How do I do this?
>
>Thanks

date: Sat, 11 Oct 2008 13:04:09 -0500 author: Chip Pearson