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
   41   42   43   44   45   46   47   48   49   50   51