473,396 Members | 1,938 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Sorting Problem (maybe)

15
I noticed something when trying to sort a list of names. It may have been happening all the time and I never noticed it, but I'm not getting the results I'm expecting. I have three columns that contains each part of the person's name. Column A has the Last Name, Column B has the First Name and Column C has the Middle name. Given the list below:

Hernandez Juan Jose
Hernandez Juan Aletto
Hernandez Juan
Hernandez Juan Jesus

when I sort by LastName then FirstName then MiddleName (all in the same sort) the results are not what I think they should be. The instance where there is no middle name always sorts to the bottom of the list. The three names where a middle name exists sort correctly.

My problem is if I were to do this by hand for, say, putting folders into a filing cabinet I would follow the alphabetizing rule that says "nothing comes before something" and I would put the folder with no middle name in the front with the other folders behind it. Excel doesn't seem to follow this rule.

I'm sure I'm missing something. Any idea why this occurs?
Nov 30 '16 #1

✓ answered by Luuk

'Empty cells' are always sorted as last

One workaround could be to put a spec in the 'empty cell', which should make it not empty anymore.

Google will find some other workarounds too
(excel sort empty cells first site:microsoft.com)

1 2003
Luuk
1,047 Expert 1GB
'Empty cells' are always sorted as last

One workaround could be to put a spec in the 'empty cell', which should make it not empty anymore.

Google will find some other workarounds too
(excel sort empty cells first site:microsoft.com)
Dec 17 '16 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Travis Pupkin | last post by:
Hi, Can anyone point me to a good online tutorial (preferably for slow learners) about advanced handling of arrays, like re-sorting the data, etc.? Thanks.
2
by: Alan Searle | last post by:
I find that I can display structured data very nicely using XML with an XSL template. As an extra 'goodie', I would like to give users the ability to sort that data (for example with a button...
4
by: suzy | last post by:
hello. how can i sort data in a dataset? all the examples i have seen on msdn, etc are sorting a dataview. this works fine, but i want to return the results in xml and the dataview doesn't...
6
by: Michel | last post by:
Hi All, I need to loop through a sorted datatable. Looping is not a problem, but sorting is. The datacolumns on which I want to sort, exists of numbers, which causes the 10 to appear before...
4
by: FBM | last post by:
Hi, I am working on a program that simulates one of the elements of ATM. The simulation stores events which occurs every some milliseconds for a certain amount of time. Every time that an event...
4
by: samb | last post by:
When I use manual databinding to a GridView control, as bellow. 'Retrive a DataSet from database Dim ds As DataSet = uda.GetUsers(conectionString) 'gvUsers - The GridView gvUsers.DataSource...
8
by: DierkErdmann | last post by:
Hi ! I know that this topic has been discussed in the past, but I could not find a working solution for my problem: sorting (lists of) strings containing special characters like "ä", "ü",......
10
by: MattC | last post by:
Hi, I wanted to take advantage of the Row_Number feature of SQL 2005 to to DB side paging. However, currently I perform my sorting on the front end. If I perform a sort and then ask for page...
3
by: =?Utf-8?B?YmJkb2J1ZGR5?= | last post by:
I have a question that maybe somebody can help me out. I have a gridview that is bound to a sqltable, and I have created two template columns. I am having problems getting the sorting to work....
3
KevinADC
by: KevinADC | last post by:
If you are entirely unfamiliar with using Perl to sort data, read the "Sorting Data with Perl - Part One and Two" articles before reading this article. Beginning Perl coders may find this article...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.