Tuesday, October 21, 2014

yogi_Pull Unique Vales From Field1 And The Corresponding Value Of Their Latest Instance In Field2

                 Google Spreadsheet   Post  #1801
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-21-2014
post by  M Umair
Google spreadsheet: Retreving only last row from multiple finds against given query
Consider the following table
xyz      cancel
abc      active
xyz      active
query against xyz will bring
xyz      cancel
xyz      active
I am only interested in last entry (which is the latest data) and more specifically in state (i.e active)
Is there any way to perform this query using google query?
In the following is presented one way

No comments:

Post a Comment