With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, January 13, 2016
yogi_Look In DataCase Table And Delineate If Error(s) Are Found Any Where in The Table
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.