Page 46 - ThinkGPT_V2.1_C6_Flipbook
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 button.








                                                                                                 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 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 Previous   11 Click on the OK button.
                               Term column in descending order.



                  The data will be sorted according to the criteria defined.








                       44    Premium Edition-VI
   41   42   43   44   45   46   47   48   49   50   51