Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Novice
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
Reply

Tags
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 06:53 AM.


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