Hello,
I am trying to find a formula to find same first three digits of zibCode in a big data column. return value to be "1" or "0".
example:
zibcode
59527
59528
59523
59505
80120
80133
80122
Thank you for your help.
Thank you for the extra detail. I've attached a solution for you. Please let me know if you have any issues.
You can use left([zibcode], 3) to extract the first 3 digits and use that to compare. I can help you further with a workflow if you provide further detail and an example of what you expect the output to look like.
Hi,
I have attached a sample of my data sheet.
Requirement:
For this case, rural is defined as an area with less than 100,000 people. To simplify this analysis, areas are defined as having the same first three digits of the ZIP code.
