how to prevent zero error message for logarithmic plots

  • Thread starter Thread starter jlrosner
  • Start date Start date
J

jlrosner

Somewhere in a very large file, there is a zero placed in a logarithmic plot.
Everytime I use the file I get the repeated error message that this problem
exists. Unless Excel can show me where in this 35000 line sheet the problem
exists, I dont want to repeatedly get this message. It effectively prevents
me from using the file.
 
Simply do a find (Ctrl+F)
Look for "0"
Under options, look at values, and match entire cell contents.
 
Back
Top