Multiple Occurences within a range

[ExcelMonkey]

I am checking a cells to see if they have hard coded data
in them (i.e. A2 + 1). However, I have a lot of annual
dates in my spreadsheets that are generated by adding 1 to
to the value in the preceding column(i.e. B2 = A2+1). So
the "+ 1" will get picked up in this query.

Is there a way to check and see if the cell that I am
evaluating is within a range of cells that all have the
same formula type (i.e. a cell with "+ 1" within a range
of cells with "+ 1" would be flagged and ignored in my
query)
Thanks

 

[Tom Ogilvy]

Only by building the list youself through looping and examining the formula.

There are goto special options for row differences and column differences -
you could play with these, but I think your differences are too great for
these to be useful.