Wednesday, October 31, 2012

yogi_Workaround For Querying A Field Of Mixed Data Type And Extracting Numeric Values Only


                                           Google Spreadsheet   Post  #842
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 31, 2012
user SagRU said: (http://productforums.google.com/forum/?zx=gdxpen6jynp#!category-topic/docs/spreadsheets/V56zP1Ts-Ys)
Query (only numeric values)
Hello!

Is it possible to make QUERY function copy only numeric values? For example, I have a formula:

=QUERY(B1:E100,”select B").

Let's assume, that column B contains both text and numeric values. I need to get only numeric values while skipping text ones.

Thanks in advance!

----------------------------------------------------------------------------------
following is a solution to the problem