Forum Discussion
00264657
Jun 20, 2017Copper Contributor
Returning multiple results in one cell
The Excel file shows cities and what county they are in. Instead of it being seperated, I would like all the cities in one county such as "West Palm Beach, Riviera Beach" in one cell and Palm Beach C...
dilipandey
Jun 20, 2017Copper Contributor
Hi 00264657,
Do you need the output for Country as it is there for Zip codes for "West Palm Beach, FL" ?
I am referring cell D5011 as output for Zip codes.
Regards,
DILIPandey
SergeiBaklan
Jun 20, 2017Diamond Contributor
Dilip, i guess for County, not Country; and that's continuation of this https://techcommunity.microsoft.com/t5/Formulas-and-Functions/Matching-Zip-Codes-to-City/m-p/74093#M749 task