Track Entries

[y2k]

I've got a spreadsheet which automatically enters a value in Column C based on the date entered in Row B. However, I need to make sure that the value only gets entered in Row C once. Can I enter another row (hidden) that will track the fact that the value has already been entered in Row C and will not enter it a second time. Please help!!!!!
This message was edited by y2k on 2002-02-26 05:33

 

[Juan Pablo González]

The value in Column C how is "automatically entered" ? formula ? VBA ? what's the condition to enter it ? Care to post 10 lines of data along with expected results AND code if you're using any OR formulas if any as well.

 

[y2k]

A formula as follows "=if(b1>=37622,47,0)". 37622 is Jan-1st-2003. This is copied down about 50 rows replacing 1 with 2 etc... However, because the argument says "greater than or equal to" (which it has to) it will generate 47 each time a date higher than Jan 1st 2003 is entered. I only want it to be generated once, so therefore I need to track somewhere, the fact that 47 has been entered and put it in the if statement so that it knows now to enter it again. Am I making sense????

I'll try anything once!!

thanks

On 2002-02-26 05:58, Juan Pablo G. wrote:
The value in Column C how is "automatically entered" ? formula ? VBA ? what's the condition to enter it ? Care to post 10 lines of data along with expected results AND code if you're using any OR formulas if any as well.