Excel sheet formula


how can I accomplish this.

have two columns of data one date the other sine wave data.

i want to write date and related data only once when slope of data changes and ignore fallowing data and date until slope changes again and write only once that date and data point once's again.

if I write =if(slope>0,date,"")or =if(slope<0,date,"") it keeps writing date till slope changes.

i only want date and related data only once and ignore the rest till slope changes again.

how to make it write related data with date only one time till slope changes agai in excel sheet not VBA formula?

is this possible in excel sheet?



Even though it may seem scary at first, VBA and Macros really are the way to go here.
don (rep: 1551) Jul 2, '18 at 9:42 am
Add to Discussion



Worksheet formulas can't write anything to a worksheet. Only the user can do that or a computer progam (f.i. VBA) which can act on behalf of the user.

A formula like =IF(Slope>0,Date,"") can monitor another cell, in this case the cell which contains the value for Slope. This can be set up. However, it isn't possible to write only if there is a change: it either writes or it doesn't write.

One might think of writing a value like 1 or 0 (True or False) to yet another cell to indicate if the Slope value was written once, and let the formula monitor both the Slope cell and the one that indicates whether a date was written before. That is possible, too. However, the cell indicating True or False would need to contain a hard value, not a formula, and the only way to enter a hard value is for the user to do it - or a computer program acting on behalf of the user.

A program to log changing values of a cell is pretty much standard fare for VBA. Why is it that you want to avoid using it?


Answer the Question

You must create an account to use the forum. Create an Account or Login