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