On 23 mar, 22:40, kingie wrote:
i have a list of sequential numbers eg 1 to 100.
I have a second list of numbers eg 5,6,23,38,90
I want to remove the numbers in the second list from the first list.
Leaving me a list of numbers 1 to 100 minus the 5 numbers in the second list.

Hello,

I would suggest using the vlookup formula in the column next to the "1
to 100" column. Let's say that the "1 to 100" column is column A1 to
A100 and the "5 numbers" column is in "D1 to D5". The formula in
range B1 would look like : =VLOOKUP(A1;$D$1:$D5;false) . This formula
must be copied in column B from 1 to 100. This will return the value
if it's a common value or an error #N/A if not.
In a 2nd step you can also use the ISERROR function.

Hope this helps