Wednesday, January 13, 2016

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   Jan-13-2016
post by: Mark Spencer:!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.