Wednesday, June 11, 2014

yogi_Pull From 'Value List' Those values That Lie Between The Instance of 'Selected value 1' and 'Selected Value 2'


                                         Google Spreadsheet   Post  #1666
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-11-2014
post by JFC111: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kUKFTj3TtjQ)
Return a series of values between 2 references

In my sheet I start by selecting Value 1. Then I select Value 2
The Desired Results should return all values in sequence that are equal to or greater than selected value 1 and equal to or less than selected value 2
What would the formula be in CELL A5 that returns the list?

Thanks
--------------------------------------------------------------------------------------------------------------------------------------------------