Saturday, May 31, 2014

yogi_From Multiple Entries By Same Name In Column A Pull Data For First Instance Of Each Name


                                         Google Spreadsheet   Post  #1660
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-31-2014
post by T-Virus: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/VVVxNacfqYM)
Sheets Query return top 1 for each group
Hi, 

Is it possible to return the first and last value also rater then a min max grouped by Column. 

I just want to return the first value in the array not the minimal one. 

Thanks 
---
Here is an example: doc

It should return the first value depending on the date given by Name
------------------------------------------------------------------------------------------------------------------------------------------