Automate formula auditing (1 Viewer)

[Spence]

Hello,

I was wondering if there was a way to create an automated report that would detect and identify incorrect formulas in a column. For example, I have a column about 300 rows long that should have the exact same formula except for the first variable. I have about 20 of these rows, and each is somewhat different from the other.

 

[ezfriend]

Perhap, you can run a macro to look at the value in each row of that column and then compare it to the previous value, excluding the first variable part.