•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
i need to pull up specific text within a string of texts (search). issue is only a part of the text is returned when i need the whole text that matches with the reference
"poblacion X" appears in multiple cities/municipalities. my goal is to pull exactly "poblacion V", "poblacion 4", etc from the address column onto the barangay column. i do have a reference sheet of which poblacions appear in each city/municipality.
formula i used to fill in the barangay column from the address: =LET(
CityList, FILTER('Nested'!$E$2:$E$50000, 'Nested'!$D$2:$D$50000=[@[City / Municipality]]),
Matches, FILTER(CityList, ISNUMBER(SEARCH(CityList, [@Address])) * (CityList<>"")),
LongestFirst, SORTBY(Matches, LEN(Matches), -1),
INDEX(LongestFirst, 1)
)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#financial modeling with spreadsheets
#poblacion
#address column
#barangay column
#reference sheet
#pull up
#CityList
#FILTER
#SEARCH
#Matches
#ISNUMBER
#Municipality
#multiple cities
#Nested