I need to search a column of data to find changes to the numbers either higher of lower. is there any way to say {find next <>} when searching a column of data?
You can use a macro, or a column of helper formulas. Any preference?
To hlep, though, we nned to know what you mean by differences... numbers
that are higher or lower than the cell above, or some preset level?
HTH,
Bernie
MS Excel MVP
I need to search a column of data to find changes to the numbers either
higher of lower. is there any way to say {find next <>} when searching a
column of data?
