Sunday, January 27, 2013

yogi_Extract Unique Values From Column A Of Sheet1 Sheet2 Sheet3 Filtering Out Entries Greater Than A Specified Number And Sort In Ascending Order

                                          Google Spreadsheet  Post  #991

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 27, 2013
user Testus said:(!category-topic/docs/spreadsheets/BgPI0d9qyQ8)

this post addresses another question in the preceding thread ...

I ran into an additional problem.

I need to filter out any number above 3999 that gets retrieved from the other sheets. I can't wrap my head around how do it with such a complex formula.

assuming entries in column A of Sheet1 Sheet2 Sheet3 are all numeric, following is a solution to the problem