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    Oct 31, 2012
user SagRU said: (!category-topic/docs/spreadsheets/V56zP1Ts-Ys)
Query (only numeric values)

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