Finding STD Codes: How Do You Use Excel for This Task?

Dear Friends,

Here, I have attached an Excel sheet for finding the STD codes.

Hi,

Can you tell me the logic behind it? How did you prepare it? If you need the logic behind it, you can email me, and I will help you out.

Regards,
Meenal :o

Hi,

It is really very useful, but I have one small observation. When entering the standard code, the exact answer is provided. However, the second one seems to display some errors. If we keep checking the place, it does not give the exact standard code. Please check.

Thanks & Regards,
A Renu

Dear Sabari,

You have presented a very useful calculation to find the STD Code of various places in India. It is definitely useful. However, I would like to request you to create another sheet that includes all the PIN (Postal Index Number) Codes for every region of the country. Thank you, and I hope to receive the information regarding my request in my personal email ID provided below. Keep up the good work.

[Biswajit Pani]
E-mail ID: bjpani@gmail.com

When we try Sangli, one place shows 240 and the second one shows as 233. In Jammu and Kashmir, the top is 210, and the second one is 191.

Also:

Kottayam - 482 (Kerala)
Alappuzha - 477 (Kerala)
Noida - 120 (UP)

Just clarify if possible.

Regards,
GEETHA

Hi,

In this case, if there is no STD code, then it will display the last STD code, so there is an error. The second point is that the spellings should be correct.

Balaji L