jeremyweck
New Member
- Joined
- May 24, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
For starters this cannot be in VBA the intended users are not familiar enough with VBA to maintain the document. That being said im 90% of the way there. I have one cell with 2 or 3 number values between 1 and 35 and another cell returning all the values that are inside that cell. My only problem is that it is treating multiple digit numbers as individual integers. 1 and 32 is returning values for 1, 2, 3 and 32 and all i want is 1 and 32. I honestly think im right on the edge of it but i just cant seem to get my brain there.
My current formula
=TEXTJOIN(", ", TRUE, IF(COUNTIF(C2, "*"&$A$2:$A$35&"*"), $B$2:$B$35, ""))
My current formula
=TEXTJOIN(", ", TRUE, IF(COUNTIF(C2, "*"&$A$2:$A$35&"*"), $B$2:$B$35, ""))