excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
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
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