This is probably an easy problem for everyone but I have no clue.

I have two columns A and B filled with numbers. Column A has the identifier number and Column B has number that represents intensity for the data set.

Column A can be anything from 75-1000, however, sometimes the adjacent rows are not sequential (i.e. 101, 102, 104).

1) Is there a way to automatically check for skipping numbers in Column A.

2) When it finds a skipped number, insert a row for column A and B.

3) Then put the correct number in Column A (i.e. 103) then put 0 in for column B

Any help would be tremendous.

I'm studying chemistry and I need to sort thousands of data sets in order to input them for statistical analysis.

Jerry-

I have two columns A and B filled with numbers. Column A has the identifier number and Column B has number that represents intensity for the data set.

Column A can be anything from 75-1000, however, sometimes the adjacent rows are not sequential (i.e. 101, 102, 104).

1) Is there a way to automatically check for skipping numbers in Column A.

2) When it finds a skipped number, insert a row for column A and B.

3) Then put the correct number in Column A (i.e. 103) then put 0 in for column B

Any help would be tremendous.

I'm studying chemistry and I need to sort thousands of data sets in order to input them for statistical analysis.

Jerry-

## Comment