how do I sort a column the 2nd time by non repeating #s?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have already sorted a spreadsheet one time by numbers in decending order.
Now I want to sort by the non repeating numbers in that column.
 
Hi
not really sure waht you're trying to do. Could you give an example?
 
You could add a column to the worksheet, and use it in the sort.

For example, if your numbers are in cells A2:A24, enter the following
formula in cell B2:

=IF(COUNTIF($A$2:$A$24,A2)>1,"",A2)

Copy the formula down to the last row of data
Select a cell in the table
Choose Data>Sort
Choose to Sort by column B, then by column A
 
I first sorted in numerical order like this 1,2,2,2,3, 3,4,4,4,4,4,5,6,7, in
a column
Now I want to sort that so that any numbers that are not repeated are either
at the top or bottom. So now it would look like 1, 5, 6, 7,2, 2, 2, 3, 3, 4,
4, 4, 4, 4,
Does that make sense?
 
Use an extra column with a COUNTIF() like

=COUNTIF(A:A, A2)

and use that as an extra parameter in the sort.
 
Where do I enter the COUNTIF( )? Do I enter that in the sort by field? OR do
I add a column?
 
In fact, look at Debra's suggestion, that should work better.
 
Hi
use a helper column with a formua such as:
=COUNTIF($A$1:$A$100,A1)
and copy down
now sort with this column
 
I have been trying the formulas. For some reason I am not having any luck
with my spreadsheet. I did try it on a spreadsheet that I made up fake info
in the spreadsheet and it seemed to work. Maybe it has something to do with
the spreadsheet I have copied from.

Thank you all for your help. I will try again tonight and if I have more
questions I will let you know.

Thank you,
Terri
 
thanks for your help
Terri

Frank Kabel said:
Hi
use a helper column with a formua such as:
=COUNTIF($A$1:$A$100,A1)
and copy down
now sort with this column
Click to expand...
 
You must log in or register to reply here.

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

Compare one cell to another 2
How to sort entire spreadsheet by one column sort 5
Auto filter drop down box 1
Sorting Pivot Table by Total 1
Sorting Columns 2
Sorting and Formulas 1
Sorting Numbers 3
sorting range 1

Back
Top