Hi. I have an inventory of items numbered 1-1000. A physical verification was done and the serial numbers of the items found present were noted. I have entered the list into excel and used sort command to arrange in ascending order.

Is there a way to formulate a second column having a list of the serial numbers of missing items. In essence the list has to be derived from '1-1000' minus the first column.

Thanks in anticipation.