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.'
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