Category: Sorting

How to Sort the Sorted List?

Learn Excel, Sorting

Hi there,

 

Have you come across how to sort the list which is ALREADY sorted? which means sorting the list which has sorted, understood, right? This was learnt in my recent training sessions conducted in Bangalore, India. So, eager to tell you. Here we go:

How to do Sorting with in a sorted list using Excel?

 

WHAT IS A SORT?

A simple Sort is nothing but arranging the data in a alphabetical order, say A to Z (the word starts with A will list first, if not A then check for B and list's as first and it proceeds) or Z to A. Otherwise it takes the numbers to sort depends on the weight of the number.

 

First, Download Working file from here.


HOW TO DO AN ADVANCED SORT?

This is a very nice technique to learn. 

First, select the data which needs to sort and goto DATA ribbon and click on SORT in Sort & Filter Group.

 

This is the window which helps to sort the data

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.