Forum Discussion

busam775's avatar
busam775
Copper Contributor
Sep 12, 2022

Relationship between cells

Hi all,

 

I'm currently analyzing extensive data from Zip codes in many states, such as income, population, and housing units. I'd like to compare the primary zip code to the zip codes of the nearby neighborhoods.

For example, 30311 must be compared to these zip codes (30310,30314,30318,30331) 

The idea is that when I write one of these codes, the neighborhood zip codes are automatically split in another cell, along with the data that I will fill later.

Per Zip3031130310303143031830331
Current Pop35,52328,59725,75257,13665,996
2010 Pop.32,21826,91222,02049,73654,094

 

I would be grateful if anyone could tell me how to create this formula.

 

Thank you

 

Hashed 

 

6 Replies

    • busam775's avatar
      busam775
      Copper Contributor

      HansVogelaar 

      Hello Hans, thank you for your reply

      I have a list of zip codes with formulas that calculate the distance between two zip codes, and this is no longer an issue because I can use the filter to find the nearest zip codes by any range I prefer.

      Now I'm having difficulty to compare the zip code to other zip codes in each cell to get the result. to save time, I think that a search box would be a better option. Kindly see the picture below. appreciated that 

      data 

       

Resources