The last two entries in a range won't sort

B

bibbis

I have a list of items in an excel sheet. I sorted the items, and they sorted
fine. Then I added two items at the end of the list, but they won't sort
with the rest of the list. When I switch between ascending and descending,
the original items reverse order, but the two new entries just stay where
they were.

I've confirmed the items are all numbers, no characters.

Help!!!
 
S

Sean Timmons

Are there any empty rows between the top of the list and these 2 new entries?
Including hidden rows...

You can always force them to sort by highlighting the entire table of data
with aded rows and re-sorting...
 
G

Gord Dibben

How did you confirm the data to be numbers?

Simply formatting as number or general will not change the format if the
"numbers" are text.

I would add this formula in a helper column to double-check.

=ISNUMBER(cellref) do you get TRUE or FALSE?


Gord Dibben MS Excel MVP
 

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

Finding the right style field in VBA 0
excel 2011 won't sort alphabetically 7
Finding the proper style field and the numbered paragraph value within the style 0
Enhanced paragraph sort - is it possible? 0
VBA works in orignal but fails in copy of database 1
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
Sorting in Excel 2
Sort partially hidden data 1

Top