yogi_Look In DataCase Table And Delineate If Error(s) Are Found Any Where in The Table

Google Spreadsheet   Post  #2018

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-13-2016

post by: Mark Spencer:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/P46JU_s1m84;context-place=mydiscussions
Searching a range for a specific value
I want to test a range for the presence of a specific value, is this possible.

For example, I have a data set containing calculated and non-calculated fields. Some of the calculated fields test for error conditions in data elements in their row and return "ERROR" if met.

I want a separate sheet to test (TRUE/FALSE) for the presence of any errors anywhere in the given range.

Thanks

--------------------------------------------------------------------------------------------------