Page 46 - Digicode_AI_class_6
P. 46
Custom Sort
If more than one column is to be sorted in such a way that the first column is in ascending order and
if some data is the same for more than one row, then the second column of such rows gets sorted in
descending order. You can do this in Excel using Custom Sort.
To use Custom Sort, follow the given steps:
2 Click on Home tab. 3 Click on the Sort & Filter command.
4 Click on
the Custom
Sort option.
1 Select the range of columns to
be sorted.
9 Click on the Add 8 Click on the Order box to select
Level button to define 7 Click on the Sort On box A to Z (for text) and Smallest to
a new criteria. to select Cell Values option. Largest (for numbers).
5 Check My
data has
6 Click on headers
the Sort by checkbox if
box to select the selected
a column columns
head for have a
sorting. heading at
the top.
10 Repeat steps 6 to 8 to sort Marks in 11 Click on the OK button.
previous term column in descending order.
The data will be sorted according to the criteria defined.
44 DigiCode AI-VI

