ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I cause a sort to quit seeing a normal row as a header row (https://www.excelbanter.com/excel-worksheet-functions/107374-how-do-i-cause-sort-quit-seeing-normal-row-header-row.html)

Anntessie

How do I cause a sort to quit seeing a normal row as a header row
 
I have set up 10 Scheduling boards for a printing company. Column B is a
5-digit job number, but is not one of the sort criteria. All the boards were
set up exactly alike. PROBLEM: 2 of them see header rows; 1 sees line 2, the
other sees line 1, so the sort criteria needs to re-established multiple
times per day on those two boards. If I eliminate the job number in that row
only, it retains the sort criteria and the problem goes away. All the other
boards retain the sort criteria and work perfectly. Column B's cells are
formatted as "text" on all the boards, but I have tried re-formatting those
two boards as "number" and re-entering the data. Makes no difference. There
is no visible difference on the boards! Help!



All times are GMT +1. The time now is 06:48 PM.

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