Page 46 - CG_v2.1_flipBooks_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    Computer Genius (V2.1)-VI
   41   42   43   44   45   46   47   48   49   50   51