Forum Discussion

ethi_nix's avatar
ethi_nix
Copper Contributor
Jan 27, 2024

Multiple Zipcode of one city and one state to be clubbed

My excel file contains unique Zipcodes in column A and the corresponding city in column D and corresponding state in column F. I want to club all Zip codes of a particular city AND a particular state...
Excel
Macros and VBA
ethi_nix's avatar
ethi_nix
Copper Contributor
I want all the columns in the output. I have sent the full file to you via private message. Please check. Thanks
Lorenzo's avatar
Lorenzo
Silver Contributor
Jan 27, 2024

ethi_nix 

 

I want all the columns in the output

OK, but given Lat & Long are unique per State & City (I didn't look at the other fields), your output will likely have the same #rows as your input. I guess this is not what you expect. Think about it and let me what should be done

 

I'm gonna be off from the remaining of the day...

  • ethi_nix's avatar
    ethi_nix
    Copper Contributor
    Jan 28, 2024
    I didn't foresee that. Let come back to you.
    • ethi_nix's avatar
      ethi_nix
      Copper Contributor
      Jan 31, 2024
      I have made some alterations at my end as such this would not be needed. Thanks anyway for your help.
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jan 31, 2024
        OK, Thanks for keeping me posted
        Cheers

Resources