Forum Discussion
Excel formula help
Hi, We need help please help us as soon as possible I need a formula that can find the district from the address list and output it to another column? Microsoft Excel 2007 version
If you want us to help you. please provide detailed and specific information.
- *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.
