A-Z sort not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2600613%22%20slang%3D%22en-US%22%3EA-Z%20sort%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600613%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20in%20Windows%2010%2C%20Office%20365.%26nbsp%3B%20I%20have%20a%20multi%20tab%20spread%20sheet%20%26amp%3B%20copied%20a%20specific%20column%20from%205%20of%20the%20tabs%20into%20a%20new%20tab%20%26amp%3B%20am%20trying%20to%20sort%20it%20A-Z.%26nbsp%3B%20It%20will%20sort%20the%20info%20from%20the%201st%204%20tabs%2C%20but%20does%20NOT%20sort%20the%20info%20from%20the%205th%20tab%20in%20with%20the%20others.%26nbsp%3B%20I%20have%20tried%20the%20following%3A%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3Echecked%20that%20there%20weren't%20any%20leading%20spaces%3C%2FLI%3E%3CLI%3Eremoved%20all%20fill%2Fcolor%20coding%3C%2FLI%3E%3CLI%3E%3DCLEAN%20formula%3C%2FLI%3E%3CLI%3Epasted%20the%20info%20that%20wouldn't%20sort%20into%20the%20middle%20of%20the%20info%20that%20was%20sorting%3C%2FLI%3E%3C%2FUL%3E%3CP%3EUltimately%2C%20I%20would%20like%20it%20to%20sort%20A-Z%20with%20color%20coding%26nbsp%3B%20so%20I%20can%20see%20if%20a%20group%20name%20is%20showing%20on%20one%20or%20more%20tabs.%20(there%20is%20probably%20a%20more%20smarty%20pants%20way%20to%20do%20this....maybe%20a%20pivot%20of%20some%20sort%20but%20I'm%20not%20skilled%20with%20those%20yet)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20input%20would%20be%20appreciated%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2600613%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm in Windows 10, Office 365.  I have a multi tab spread sheet & copied a specific column from 5 of the tabs into a new tab & am trying to sort it A-Z.  It will sort the info from the 1st 4 tabs, but does NOT sort the info from the 5th tab in with the others.  I have tried the following: 

  • checked that there weren't any leading spaces
  • removed all fill/color coding
  • =CLEAN formula
  • pasted the info that wouldn't sort into the middle of the info that was sorting

Ultimately, I would like it to sort A-Z with color coding  so I can see if a group name is showing on one or more tabs. (there is probably a more smarty pants way to do this....maybe a pivot of some sort but I'm not skilled with those yet)

 

Any input would be appreciated  

0 Replies