Sorting issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2300494%22%20slang%3D%22en-US%22%3ESorting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300494%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20of%20tennis%20information%20with%20names%20records%2C%20scores%2C%20ranks%2C%20dates%2C%20etc.%3C%2FP%3E%3CP%3EI%20set%20up%20a%20sort%20that%20apparently%20works%20for%20everything%20except%20one%20group%20of%20information.%3C%2FP%3E%3CP%3EIt%20is%20working%20for%20the%20men's%20team%3C%2FP%3E%3CP%3EHowever%2C%20one%20match%20of%20the%20ladies%20scores%20will%20not%20sort%20properly.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20and%20rechecked%20everything%20that%20I%20can%20think%20of.%3C%2FP%3E%3CP%3EThe%20men's%20match%20vs%20the%20same%20team%20sorts%20properly%2C%20but%20for%20some%20reason%2C%20not%20so%20with%20the%20ladies'%20team's%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20sheet%20is%20the%20Alpha%20(all)%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2300494%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2300520%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039062%22%20target%3D%22_blank%22%3E%40Coach_R%3C%2FA%3E%26nbsp%3BMy%20goodness!%20What%20are%20we%20looking%20at%3F%20Perhaps%20you%20can%20identify%20what%20exactly%20you%20are%20trying%20to%20sort%20on%20and%20where%20exactly%20(which%20cells)%20it%20goes%20wrong%20and%20why.%20What%20do%20you%20expect%20to%20see%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2300542%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300542%22%20slang%3D%22en-US%22%3EYour%20data%20has%20no%20HEADERs%20so%20it's%20quit%20confusing%20for%20me%20and%20possibly%20for%20other%20readers%20too%2C%2C%2C%20and%20if%20I'm%20not%20wrong%20Male%20%26amp%3B%20Female%20are%20M%20%26amp%3B%20L%20%2C%2C%20plzz%20specify%20on%20which%20column%20you%20wanna%20to%20SORT%20record%20!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2300640%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300640%22%20slang%3D%22en-US%22%3EThis%20is%20a%20record%20of%20a%20tennis%20team's%20results%20throughout%20the%20year%3CBR%20%2F%3EColumn%20A%20is%20M%20(men)%20or%20L%20(ladies)%3CBR%20%2F%3EColumn%20B%20is%20rank%201-5%3CBR%20%2F%3EColumn%20C%20is%20type%20of%20match%20S%20(singles)%20or%20D%20(doubles)%3CBR%20%2F%3EColumn%20D%20is%20the%20name%20or%20Names%20of%20the%20individual%20player%20or%20the%20last%20names%20of%20the%20doubles%20team%3CBR%20%2F%3EColumns%20E%20through%20P%20are%20not%20involved%20in%20the%20sort%3CBR%20%2F%3EColumn%20Q%20is%20the%20date%20of%20the%20match%3CBR%20%2F%3E%3CBR%20%2F%3EOnly%20lines%20100-106%20are%20not%20working%20correctly.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20attempting%20to%20see%20all%20of%20the%20Men's%20(Column%20A)%20matches%20first%20-%20organized%20in%20the%20following%20priority%3A%3CBR%20%2F%3EColumn%20D%20-%20names%20alphabetically%20(apostrophes%20do%20not%20cause%20an%20issue%20BTW%20...%20I%20have%20seen%20in%20other%20rows%20that%20some%20names%20start%20with%20apostrophes%20and%20some%20don't%20...%20but%20they%20do%20not%20affect%20those)%3CBR%20%2F%3EColumn%20Q%20-%20dates%20of%20matches%20played%20from%20oldest%20to%20most%20recent%3CBR%20%2F%3EColumn%20C%20-%20removed%20from%20the%20original%20sort%3CBR%20%2F%3EColumn%20B%20-%20removed%20from%20the%20original%20sort%3CBR%20%2F%3EIt%20appears%20to%20be%20glitching%20in%20the%20name%20sort%20for%20these%20lines%3C%2FLINGO-BODY%3E
New Contributor

I have a sheet of tennis information with names records, scores, ranks, dates, etc.

I set up a sort that apparently works for everything except one group of information.

It is working for the men's team

However, one match of the ladies scores will not sort properly. 

I have checked and rechecked everything that I can think of.

The men's match vs the same team sorts properly, but for some reason, not so with the ladies' team's information.

 

The sheet is the Alpha (all) sheet.

5 Replies

@Coach_R My goodness! What are we looking at? Perhaps you can identify what exactly you are trying to sort on and where exactly (which cells) it goes wrong and why. What do you expect to see?

Your data has no HEADERs so it's quit confusing for me and possibly for other readers too,,, and if I'm not wrong Male & Female are M & L ,, plzz specify on which column you wanna to SORT record !!
This is a record of a tennis team's results throughout the year
Column A is M (men) or L (ladies)
Column B is rank 1-5
Column C is type of match S (singles) or D (doubles)
Column D is the name or Names of the individual player or the last names of the doubles team
Columns E through P are not involved in the sort
Column Q is the date of the match

Only lines 100-106 are not working correctly.

I am attempting to see all of the Men's (Column A) matches first - organized in the following priority:
Column D - names alphabetically (apostrophes do not cause an issue BTW ... I have seen in other rows that some names start with apostrophes and some don't ... but they do not affect those)
Column Q - dates of matches played from oldest to most recent
Column C - removed from the original sort
Column B - removed from the original sort
It appears to be glitching in the name sort for these lines

@Coach_R The first few ladies matches are labeled "L ", thus, capital L with a space. remove the space and resort. Then it should work.

Thank you VERY much!

It seems to always be in those tiny details.

It works beautifully now!

 

@Riny_van_Eekelen