Maharashtra TIN validation Utility in excel (Structural Validation)

Enter a list of TINS in A column. Copy paste the formula in column B till the cell you have entered the TIN. It will show True or False.

True signifies it is structurally valid and false signifies it is structurally invalid.

For more details of TIN you can use Know your TIN from mahavat.gov.in

THIS EXCEL UTILITY ONLY SHOWS CORRECT TIN ON THE BASIS OF STRUCTURE 

THIS CAN HELP TO VALIDATE TINS GIVEN BY CLIENT. IN CASE OF ANY MISTAKE BY CLIENT IN PUTTING TIN IT WILL BE TRACED EASILY AND THEN THE SAME CAN BE COPY PASTED TO J1 AND J2.

Download Maharashtra TIN validation Utility in excel (Structural Validation)