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?