Multiple Occurences within a range

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

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
 
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.
 
Back
Top