Google Spreadsheet Post #1192
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 12, 2013
user Fabio Magalhaes (https://productforums.google.com/forum/#!mydiscussions/docs/tdvJ7kDVTFA)
Hello Hyde and Yogi. Thank you two for the answer. Unfortunatelly, I still cound'nt solve my issue.
Following yourt advices, specially from Yogi (because I don't understand very well the query function Hyde suggested) I get a circular dependency.
The problem is that I really have a circular operation there, and now I do not know how to get around it. The dependency appear because I select the value from a validation, then later I'm trying to find their position.
Here is the link to the original spreadsheet:
https://docs.google.com/
I hid the useless sheets for this issue.
I'm trying to find the address of Perícias!H3 in the interval Lista!F2:AA39. I can find the row with the formula match, but the column search return the circular dependency.
Greeting :)
-----------------------------------------------------------------------------------------------------------------------
let us have a look at the following
No comments:
Post a Comment