Forum Discussion

johannsomosa's avatar
johannsomosa
Copper Contributor
Dec 16, 2024

Store a range of numbers in one cell? Excel Question

Hey Microsoft community, I'm working on a project and I'm wondering if this task I'm requesting for Excel to do is possible. If so, is it suitable I continue with Excel or with a different program...
BI & Data Analysis
excel
Excel on Mac
Formulas and Functions
m_tarler's avatar
m_tarler
Bronze Contributor
Dec 18, 2024

based on your images something like the following should work.  I'm using "CropList" to refer to the Table in the first image and I can't read the column name for the Hardiness Zone in the second image so just added the ...

=TEXTJOIN(", ",,FILTER( CropList[Crop], ISNUMBER(SEARCH([@[Hardiness Zone ....]]&"," , CropList[Hardiness Zone]&",")), "None"))

Note I added the &"," to both the search term and the list of Hardiness Zone so that a "1" doesn't match with 10, 11, ...

I added the TEXTJOIN since in a table like that you can't spill all the results 

 

johannsomosa's avatar
johannsomosa
Copper Contributor
Dec 18, 2024

Hey, this is awesome! Thank you so much for sending this solution over. I'm sorry you had to create this through the images. I would like to place this blame on Microsoft, it states its requiring permission before posting my comment. Will go ahead and try this, and post back the results! Again, thank you.

Resources