Google Spreadsheet Post #1622
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-01-2014
post by auren22: (https://productforums.google.com/forum/#!mydiscussions/docs/RZbErRJpGm0)
Query or Unique Function to return non duplicate rows from one worksheet to another.
Dear yogi,
Here is my spreadsheet, just that its based on another information, in this case the UNIQUE VALUES should be applied to column A of sheet "Original Values" and then return the adjacent columns.
I cannot query the entire sheet "
--------------------------------------------------------------------------------------------------------------------------------------------
in the following solution I first created a list of TRUE / FALSE values for column A of OriginalValues ... and the I filtered the entire data base with list of TRUE / FALSE as criteria
No comments:
Post a Comment