Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-11-2022, 04:37 AM
TerryB TerryB is offline Strange sorting behaviour in table - wrong level? Windows 10 Strange sorting behaviour in table - wrong level? Office 2010
Strange sorting behaviour in table - wrong level?
Join Date: Jun 2022
Posts: 1
TerryB is on a distinguished road
Default Strange sorting behaviour in table - wrong level?

I've a two column table. Maybe 20 or so rows.
I've sorted the table by the first column in alphabetic order. It was all fine.

I recently entered some new items in the right position.
Then I did a resort ( to make sure everything was right).
The new items don't appear in the right order. They're identical to some that were there previously ( because I'd copied and pasted them into the right position in column 1). But they appear to be sorting randomly into a lower position. The column is literally running in the order of a,b,c,d,........x,y,z,b.
I can see no visual difference. The column is a list of names and all the other entries follow alphabetic order.
I do note that the table select menu has "select level 1" as an option. And this does seem to select these aberrant entries. So they may be on some mysterious different level. But I can find no method to make them the same level, or explanation as to what these mysterious levels are. They appear to be like a little hidden minefield that only serves to destroy the table's function.

Onenote V 2205
Reply With Quote

sorting, table

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange sorting behaviour in table - wrong level? Strange Excel Behaviour with ACE OLEDB Provider Abumushfiq Excel 1 06-30-2014 04:20 AM
Strange sorting behaviour in table - wrong level? Heading level numbering in 2010 - wrong after second header level 1 taran Word 3 07-08-2013 01:12 PM
Image attachments opening with strange behaviour mothman Outlook 0 02-16-2013 08:53 PM
Strange behaviour when entering Actuals joday48 Project 4 01-15-2013 03:51 AM
Referencing a value over 255 characters within a table PLUS strange formula behaviour TishyMouse Excel 2 01-08-2013 09:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd. is not affiliated with Microsoft