How do I quickly find the formula causing an error?

[sacman]

Hello

I have a range with over 150,000 cells in a column, each containing a formula. I have a summation formula at the bottom but it is showing #VALUE!.

How do I quickly find the formula that is causing the error without scrolling through every page?




Allen

 

[Gerald Higgins]

You could try sorting the data.
Or Data, Filter.
Or Edit, Find and Replace, to search for #VALUE entries (specify that you are looking in VALUES).

 

[sacman]

You could try sorting the data.
Or Data, Filter.
Or Edit, Find and Replace, to search for #VALUE entries (specify that you are looking in VALUES).

Thanks. I ended up sorting the data that that was not what I was wanting. I run across this problem a lot and wanted a faster method.

Revision 9:30 a.m. : I just tried the Ctrl+F (Find) and searched for #Value in values. That worked great. Thanks!


Allen