Thursday, May 1, 2014

yogi_From Data In OriginalValues Create yogi_OutputWithUniqueValuesInColumnA Of OriginalValues


                                         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