Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 49 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 49

    Multiple Sort

                     If you want to sort more than one column in such a way that the first column is in ascending
                     order and if some data is same for more than one rows then the second column of such rows
                     gets sorted in descending order. You can do this in Calc using Sort option of Data menu.

                     To sort multiple columns, follow the given steps:
                     Step 1  Select the range of columns to be sorted.

                     Step 2   Select the Sort option from Data menu. The Sort dialog box will open.

                     Step 3   Click on the Column drop-down list to view the list of column headers in the Sort key
                              1 section under the Sort Criteria tab. Select a column header, such as 'Department.'

                                                               Using Data menu

                     Step 4   Click on the Ascending radio button for Sort Key 1.
                     Step 5   Repeat steps 4 and 5 to sort ‘First Name’ column in descending order under Sort Key 2.

                     Step 6  Click on the OK button. The data will be sorted according to the criteria defined.

                                       Unsorted data                                       Sorted data
                     Clickipedia

                       The sorting can also be done through Standard toolbar by selecting Sort Ascending              or

                       Sort Descending         tools for sorting in ascending and descending order respectively.

                                                                                            Using Calc as Database       47

| 44 45 46 47 48 49 50 51 52 53 54 |