excel help: sort unique cells

[LordSnailz]

simple request, I have a list of 6 digit numbers, 4000 of them, there are some unique number and there are some numbers that repeat. For example, 1,1,1,2,3,4. Does anyone know how I can get numbers? In the above example it would be 1,2,3,4. Really need this urgently, any help is appreciated!!

 

[Angrymarshmello]

Wait what the hell are you asking? Do you want the list to hide repeating numbers?

 

[HomeBrewerDude]

set up a pivot table cut and copy values and there you go.

 

[LordSnailz]

Originally posted by: yamahaXS
set up a pivot table cut and copy values and there you go.

how do you do that?

Angrymarshmello: I do want the repeating numbers, but one of them.

Like if I have a list: 23, 65, 76, 98, 23, 100, 23: It will show me only 23, 65, 76, 98, 100

 

[Angrymarshmello]

That's easy - highlight the column or row, go to Data -> Filter. Then go back to Data -> Advanced Filter, check Unique Records Only.

 

[bubbasmith99]

click somewhere in that column. see the A-->Z button? click that and they should all be ordered properly in descending order. now you can do what you want with them. voila.

 

[dighn]

Originally posted by: Angrymarshmello
That's easy - highlight the column or row, go to Data -> Filter. Then go back to Data -> Advanced Filter, check Unique Records Only.

 

[LordSnailz]

got it ... used sort command in unix, thanks!

 

[bubbasmith99]

unix?? u sure you were using excel?