Forum Discussion
janey273
Aug 30, 2019Copper Contributor
Help sorting database by date
Hi there I have a database which has a column with enrol date. I am in NZ and our date formate is DD/MM/YYYY. Currently the database is sorted by the number not date, ie 01/02/2019 comes after 01/...
Ronald_Peters
Aug 30, 2019Copper Contributor
- Highlight the range of cells to be sorted. In this example, cells A2 to E12 are selected.
- Select Home.
- Select Sort & Filter to open the drop-down list.
- Select Custom Sort to open the Sort dialog box.
- Place a check next to My data has headers.
- Under the Column heading, select the Sort by down arrow and choose Namefrom the drop-down list to first sort the data by the Name column.
- Under the Sort On heading, leave the setting as Cell Values. The sort is based on the actual data in the table.
- Under the Order heading, select the down arrow and choose Z to A to sort the Name data in descending order.
- Select Add Level to add a second sort option.
- Under the Column heading, select the Then by down arrow and choose Ageto to sort records with duplicate names by the Age column.
- Under the Order heading, choose Largest to Smallestfrom the drop-down list to sort the Age data in descending order.
- Select OK to close the dialog box and sort the data.
Hope this helps!