Forum Discussion
Excel formula help
- *The Demo Data you may download the file from here
- https://1drv.ms/x/s!Al_W0BkwmMJVig2b5VFNMiibdhNc
The data appear to have different layouts - some have commas and others don't. And the district name may consist of one word or of multiple words. So I do not see how we could extract the district from these data.
So what changes do I have to make to understand this?
Whatever data we have is of this type.
You may download list of pincodes from here All India Pincode Directory | Open Government Data (OGD) Platform India or any other resource which provides such information, add info into another sheet of your workbook and lookup district based on pincode from that sheet.
I don't think that pincodes are updated frequently.
I have no idea how to download the file by going to this link. Share with us the direct link of the file on which we can click and download the file.
Do you have a comprehensive list of the names of all districts in all states? That might help (but probably still not solve the problem completely)
