'subtract' a range of numbers from another range

[excelNewbie22]

hi!

so i have a long list of 1000 shuffled numbers with duplicates (col a) ,
which always changing,
all from within a range of 1000-1500,
(example 1001,4050, 3182, 4992, 1002, 4050 and so on)

i want to exclude constantly the first 400,
with these 400, i want to delete the duplicates,
and let's say i left with 200 unique numbers (col b),
then 'subtract' these 200's from the 500 unique numbers of the range of 1000-1500,
and then display the remaining 300 in another column (col c)

now, i've already have a way to do it,
with sorting and filtering and condition formatting,
but since i'll need to do so lot's of times,
i wonder can it be done in a shorter way?
maybe with formulas? even several?

i thought something with unique function maybe?



p.s
the range and numbers are just examples,
the originals are different,
and assuming there will be a solution i'll modify it to my needs

 

[Fluff]

Because they are probably text & not numbers, when you copied them back across xl probably converted them.

 

[excelNewbie22]

how to fix it?

 

[Fluff]

You could try text to columns on the data tab. Select the column then text to columns select delimited & click finish.

 

[excelNewbie22]

thanks thanks and thanks ! and for the patience!

 

[Fluff]

Glad to help & thanks for the feedback.