Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SORT Header Row(s) | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |