sorting range

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

I have a range of number, about a 1000 rows long, and I want to sort them in
a different column from least to greatest. Most of the numbers are repeated 2
or 3 times so I want to compile a range without any repeats as well.

Any idea how I could do this?

thanks,

Jase
 
Two steps

If in Excel 2003 or older, use Data->Filter->Advanced filter
Choose "Copy to new location: " and give it an address
Check Unique records only
Click on OK
Step 2 is to sort the new list

In Excel 2007, copy your list to an empty column and on the copied data use
"Remove duplicates" from the Data tab, then sort
 

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

Similar Threads

filtering ranges 3
writing a sort macro 2
dynamic summation 3
VBA set thick borders around non empty cells in range 0
Sorting Madness 5
macro to change graph ranges? 1
Return Just the Unique Entries From a Range of Cells 3
Sorting a sheet in VBA 2

Back
Top