Forum Discussion
Store a range of numbers in one cell? Excel Question
Hey m_tarler,
Thank you for this response. From what I understand, when instructing excel to pull up different crops based on the temperature zones or hardiness zones, we utilize the max < the value. In doing so, Excel will look for every crop, with temperature, or hardiness zone, below the the value. Is this correct?
I'll go ahead an attempt to rearrange my worksheet with MIN and MAX columns. As for the worksheet, I've attached it here. Please let me know what you think. Thank you for your time.
https://docs.google.com/spreadsheets/d/1shn8arKSoY9nkuGF7cDEFMiy8rnOWc4d/edit?usp=drive_link&ouid=113669357501570955749&rtpof=true&sd=true
you could use the max min i suggested but that was more for something like 'I live in area with a temperature of X so find all zones that include that temperature'
In this case it appears you already have hardiness zone and want all crops that include that zone so my above formula should work. I updated it based on your sheet info:
=TEXTJOIN(", ",,FILTER( USDA_Crops5[Crop], ISNUMBER(SEARCH([@[Hrdiness Zone 2023]]&",", USDA_Crops5[Hardiness Zones]&",")), "None"))But note the list of crops is large so those cells got big. i hope this is what you are looking for.