Help me sort my wines!

%3CLINGO-SUB%20id%3D%22lingo-sub-1950363%22%20slang%3D%22en-US%22%3EHelp%20me%20sort%20my%20wines!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1950363%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20wine%20display%20set%20up%20almost%20like%20a%20spreadsheet.%26nbsp%3B%20Columns%201-30%2C%20and%20Rows%20A-E.%26nbsp%3B%20%26nbsp%3BWines%20are%20identified%20in%20the%20system%20and%20in%20the%20storage%20room%20to%20find%20them%20easily.%26nbsp%3B%20Right%20now%20I%20have%20them%20listed%20as%20A-1%2C%20B-5%20ect.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3BIn%20my%20Excel%20spreadsheet%2C%20I%20can't%20figure%20out%20how%20to%20sort%20it%20correctly.%26nbsp%3B%20%26nbsp%3BIt%20comes%20out%20like%20this.....%26nbsp%3B%20I%20have%20also%20switched%20it%20to%201-B%2C%2010-C%20Etc%20and%20have%20the%20same%20issue.%26nbsp%3B%20Ideas%3F%26nbsp%3B%20Thanks!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-12-02%2008.12.05.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237330i3CB4CFC178654357%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-12-02%2008.12.05.png%22%20alt%3D%22Screenshot%202020-12-02%2008.12.05.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1950363%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1950470%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20me%20sort%20my%20wines!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1950470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888447%22%20target%3D%22_blank%22%3E%40Lizan1%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EWhether%20you%20write%20the%20locations%20like%20A-1%20or%201-A%2C%20they%20are%20text%20values%2C%20so%20they%20will%20be%20sorted%20alphabetically%2C%20not%20numerically.%20The%20easiest%20way%20is%20to%20use%20A-01%20if%20you%20want%20to%20sort%20on%20the%20letter%20first%2C%20then%20on%20the%20number%2C%20or%2001-A%20if%20you%20want%20to%20sort%20on%20the%20number%20first%2C%20then%20on%20the%20letter.%3C%2FP%3E%0A%3CP%3EAlternatively%2C%20use%20column%20E%20to%20store%20only%20the%20letters%20A%20to%20E%2C%20and%20column%20F%20to%20store%20the%20numbers%201%20to%2030.%3C%2FP%3E%0A%3CP%3EYou%20can%20then%20sort%20either%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a wine display set up almost like a spreadsheet.  Columns 1-30, and Rows A-E.   Wines are identified in the system and in the storage room to find them easily.  Right now I have them listed as A-1, B-5 ect.    

   In my Excel spreadsheet, I can't figure out how to sort it correctly.   It comes out like this.....  I have also switched it to 1-B, 10-C Etc and have the same issue.  Ideas?  Thanks!

Screenshot 2020-12-02 08.12.05.png

1 Reply

@Lizan1

Whether you write the locations like A-1 or 1-A, they are text values, so they will be sorted alphabetically, not numerically. The easiest way is to use A-01 if you want to sort on the letter first, then on the number, or 01-A if you want to sort on the number first, then on the letter.

Alternatively, use column E to store only the letters A to E, and column F to store the numbers 1 to 30.

You can then sort either way.