request formula
Your question is not clear as to whether you want to mark differences that
are exactly 5 or 5 or greater. If exactly 5, use this formula...
=IF(ABS(A2-A1)=5,"X","")
If 5 or more, use this formula...
=IF(ABS(A2-A1)=5,"X","")
Rick
"Ann" wrote in message
...
I have a list of data points such as 1,2,4,14 and I need to have a column
that finds each time the data points move by an absolute value of 5.
tia
|