Page 46 - Computer Genius Class 06
P. 46

Custom Sort

                     more than one column is to  e sorted in such a  ay that the first column is in ascending order and
                  i  some data is the same  or more than one ro   then the second column o  such ro s gets sorted in
                  descending order. You can do this in Excel using Custom Sort.
                  To use  ustom  ort   ollo  the gi en steps


                              2   lic  on Home tab.        3   lic  on the Sort & Filter command.








                                                                                                 4    lic   on
                                                                                                the Custom
                                                                                                Sort option.










                              1   elect the range o  columns to
                             be sorted.



                       9    lic   on  the  Add                                       8   lic  on the Order box to select
                       Level   utton  to  de ine    7   lic  on the Sort On box     A to Z   or te t  and Smallest to
                       a new criteria.             to select Cell Values option.    Largest   or num ers .




                                                                                                        5   hec  My
                                                                                                        data has
                     6   lic  on                                                                        headers
                    the Sort by                                                                         chec  o  i
                    box to select                                                                       the selected
                    a column                                                                            columns
                    head  or                                                                            have a
                    sorting.                                                                            heading at
                                                                                                        the top.





                                     10    epeat  steps     to     to  sort   ar s  in   11  lic  on the OK button.
                                     previous term column in descending order.



                  The data  ill  e sorted according to the criteria defined.





                       44    Computer Genius-VI
   41   42   43   44   45   46   47   48   49   50   51