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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
