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
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/lNt13E-jq90)
Google spreadsheet: Retreving only last row from multiple finds against given query
Hi
 
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?
 
Thanks.
---------------------------------------------------------------------------------------------------------------------------------
In the following is presented one way