calculate only once

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589
Lets say cell C1 is the result of a condition, say =if(H1=1,1,0) I want Cell C2 to look at the value of Cell B4 as soon as C1 = 1 (note, as soon as C1=1 it won't change any more). Cell C2 will then = this value, but only on this occasion. Cell B4 will change its value, but I do not want cell C2 to update. In plain language, I want C2 to take a freeze of B4 when C1 becomes 1

Confusing :)

Thanks
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi there
You could try this event macro:

Right click your sheet tab, left click View Code and paste this in the white area

Private Sub Worksheet_Change(ByVal Target As Range)
If [C1] = 1 Then [C2].Formula = [C2].Value
End Sub

This should convert C2 to a permanent value when C1 equals 1

You will need a formula like this in C2
=IF(C1=1,B4,"")


regards
Derek
This message was edited by Derek on 2002-10-14 23:11
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi again
link tells me it is unavailable
What was the question?
regards
Derek
 

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589

ADVERTISEMENT

On 2002-10-14 23:47, Derek wrote:
Hi again
link tells me it is unavailable
What was the question?
regards
Derek

Whoops,

External Data - Macro Question

Cheers from Western Oz
 

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
Hi again
External Data - Macro Question??????
Not sure I follow you, can you rephrase your question.
regards
Derek
 

The Idea Dude

Well-known Member
Joined
Aug 15, 2002
Messages
589
Sorry Derek, I was pointing you to the subject line of my question. It is probably on page 2 now, and it would be easier for you to track it down, than for me to re do the Q :)
 

Forum statistics

Threads
1,143,733
Messages
5,720,553
Members
422,291
Latest member
Deveshk

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top