Tuesday, September 18, 2012

yogi_Extract Rows That Have The First Instance Of The String In Column H

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #758   Sep 18, 2012     www.energyefficientbuild.com.

user Dakito said: (http://productforums.google.com/forum/?zx=moicavc8fpfc#!category-topic/docs/spreadsheets/dGnuUgXFkyU)
Selecting Unique Rows on a string
I have a user form to enter data and to semi clean up that data I have a string like so xxx,xxx I want to grab all rows that have a unique string. I've tried something like this  =query(E:H,"Select H,E,F where H <> ',' group by H") but get the error  ' error: Invalid query: Cannot use GROUP BY when no aggregations are defined in SELECT.' 

here is some sample rows

E F H
Group Regular -125,2100 Group Melding 1300,2300 Group Regular 1300,2300
---
Sorry Looking for something like this
E F H
Group Regular -125,2100 Group Melding 1300,2300
Basically I'm trying to filter out duplicates. I don't mind taking the values from the first on in the list but would like to hide the dublicates.
----------------------------------------------------------------------------------------------
following is a solution to the problem


No comments:

Post a Comment