Home

Sorting Data in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-667679%22%20slang%3D%22en-US%22%3ESorting%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-667679%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20sort%20my%20students'%20data%20by%20who%20needs%20remediation.%20Those%20that%20need%20remediation%20have%20a%20blank%20square%20while%20those%20that%20don't%20have%20a%20black%20square.%20I%20would%20like%20for%20those%20that%20need%20remediation%20to%20be%20at%20the%20top%20of%20each%20column%20and%20would%20like%20to%20have%20the%20cell%20colored%20red%20so%20that%20stands%20out%20to%20me%20making%20it%20easier%20to%20know%20who%20needs%20to%20be%20remediated%20at%20a%20quick%20glance.%20I%20have%20attached%20the%20spreadsheet%20with%20fictitious%20names.%20Any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3ETeresa%20Maddox%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-667679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-672422%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-672422%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F354386%22%20target%3D%22_blank%22%3E%40TMaddox%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESeems%20like%20you're%20using%20'pictures'%20for%20solid%20%26amp%3B%20empty%20squares.%20What%20if%20you%20changed%20to%20symbols%20using%20ALT%20codes%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%E2%96%A0%20%3D%20ALT%20%2B%20254%3CBR%20%2F%3E%E2%97%8B%20%3D%20ALT%20%2B%209%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you%20should%20be%20able%20sort.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EYou'll%20probably%20want%20to%20'unpivot'%20your%20data%20for%20the%20sorting%20to%20occur%20at%20the%20top.%20I%20used%20Power%20Query%20to%20do%20this%20quickly.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20533px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117293i0028653B76577E8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%224.PNG%22%20title%3D%224.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-672925%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-672925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303863%22%20target%3D%22_blank%22%3E%40ChrisMendoza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20spreadsheet%20was%20exported%20from%20a%20quiz%20website%20I%20use%20(Quia).%20How%20do%20I%20quickly%20change%20all%20the%20pictures%20to%20the%20alt%20symbols%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20your%20help!!%3C%2FP%3E%3CP%3ETeresa%20Maddox%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-674835%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20Data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-674835%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F354386%22%20target%3D%22_blank%22%3E%40TMaddox%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMulti-select%20by%20%3CSTRONG%3ECTRL%20%2B%20Left%20Click%3C%2FSTRONG%3E%20-%26gt%3B%20%3CSTRONG%3EF2%3C%2FSTRONG%3E%20-%26gt%3B%20(%3CSTRONG%3E%20ALT%20%2B%20254%3C%2FSTRONG%3E%20)%20%3CSTRONG%3E%2F%3C%2FSTRONG%3E%20(%20%3CSTRONG%3EALT%20%2B%209%3C%2FSTRONG%3E%20)%20-%26gt%3B%20%3CSTRONG%3ECTRL%20%2B%20Enter%3C%2FSTRONG%3E%20is%20how%20I%20did%20it.%20It%20was%20actually%20more%20time%20consuming%20to%20delete%20all%20the%20images%20in%20your%20small%20sample%20for%20myself.%3C%2FP%3E%3C%2FLINGO-BODY%3E
TMaddox
New Contributor

I am trying to sort my students' data by who needs remediation. Those that need remediation have a blank square while those that don't have a black square. I would like for those that need remediation to be at the top of each column and would like to have the cell colored red so that stands out to me making it easier to know who needs to be remediated at a quick glance. I have attached the spreadsheet with fictitious names. Any help would be greatly appreciated.

Thank you!

Teresa Maddox

3 Replies

@TMaddox -

 

Seems like you're using 'pictures' for solid & empty squares. What if you changed to symbols using ALT codes?

■ = ALT + 254
○ = ALT + 9

 

Then you should be able sort.

You'll probably want to 'unpivot' your data for the sorting to occur at the top. I used Power Query to do this quickly.

4.PNG

 

@ChrisMendoza 

This spreadsheet was exported from a quiz website I use (Quia). How do I quickly change all the pictures to the alt symbols? 

Thanks so much for your help!!

Teresa Maddox

@TMaddox -

 

Multi-select by CTRL + Left Click -> F2 -> ( ALT + 254 ) / ( ALT + 9 ) -> CTRL + Enter is how I did it. It was actually more time consuming to delete all the images in your small sample for myself.

Related Conversations