Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - 2632_CodeMind
P. 45

    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

| 40 41 42 43 44 45 46 47 48 49 50 |