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

T

tagback70

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.
 
D

Debra Dalgleish

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
 
T

tagback70

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?
 
J

Juan Pablo González

Use an extra column with a COUNTIF() like

=COUNTIF(A:A, A2)

and use that as an extra parameter in the sort.
 
T

tagback70

Where do I enter the COUNTIF( )? Do I enter that in the sort by field? OR do
I add a column?
 
F

Frank Kabel

Hi
use a helper column with a formua such as:
=COUNTIF($A$1:$A$100,A1)
and copy down
now sort with this column
 
T

tagback70

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
 
T

tagback70

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...
 
Top