Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How To Verify A UK National Insurance Number With Excel
Quote:Courtesy of SofiaM

To verify the validity of a National Insurance (NI) number using Excel:

Open a new Excel spreadsheet.
Enter the NI number in cell A2.
In the formula bar, input the following formula:

  "Valid NI Number",
  "Not a valid NI Number"

After entering the formula, a cell will display either "Valid NI Number" or "Not a valid NI Number" based on the input.


I just want to add a detail to this.

It doesn't confirm only NI Numbers in circulation, it satisfies what is actually a very simple algo check of what is or will be a valid NI number now or in the future.

Think Voters' roll registration for example. You don't want to cock it up with some blag random NI Number that the council will know is wrong. Use this spreadsheet and your number will pass the algo check.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Quick Reply
Image Verification
(case insensitive)

Forum Jump:

Users browsing this thread:
1 Guest(s)

Powered By MyBB, © 2002-2023 Confidentialacces is Back.