ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   why does sorting large columns create errors in top selection? (https://www.excelbanter.com/excel-worksheet-functions/56060-why-does-sorting-large-columns-create-errors-top-selection.html)

Mitch

why does sorting large columns create errors in top selection?
 
In excel 2003 when sorting a large column of numbers, over a few hundred,
they all sort properly except the top one or two. How can I avoid this or
rectify it?

MDBCT

why does sorting large columns create errors in top selection?
 
I've been "bitten" many times by the top row not sorting too. One thing I
would suggest is to always use column headers.

I'm assuming that you are using the quick sort buttons and not going to
Data/Sort....




"Mitch" wrote:

In excel 2003 when sorting a large column of numbers, over a few hundred,
they all sort properly except the top one or two. How can I avoid this or
rectify it?



All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com