Is this possible.

  • Thread starter Thread starter TyeJae
  • Start date Start date
T

TyeJae

I have a list of random numbers, some of them are the same, lets sa
like this:

5
6
9
5
10
22
5
9
45
68
8
7
12
10

Is there a way in excel to have it look at that list of numbers an
create a new list of numbers for each number in the list above withou
repeating any of the numbers? So the new list would look like:

5
6
10
22
9
45
68
8
7
12

This could save me a bunch of trouble.

Thanks,
TyeJa
 
Hi
use 'Data - Filter - Advanced Filter' and check 'Unique entries'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top