Sort the database in Excel
The following article provides detailed instructions for you to organize the database in Excel.
Sort the database in Excel Picture 1
Sorting data is indispensable when working in Excel.
1. Sort data simply.
Step 1: Select the data range to sort -> Data -> Sort:
Sort the database in Excel Picture 2
Step 2: The Sort dialog box appears, select the data fields to sort in Sort by -> select the sorting type in the Order section , for example, here sort the revenue in order from baby to big:
Sort the database in Excel Picture 3
After clicking OK, the result is:
Sort the database in Excel Picture 4
2. Sort names alphabetically.
Step 1: Insert 3 more columns, middle names and first names as shown:
Sort the database in Excel Picture 5
Step 2: Copy the entire NV Name column to the Name column -> press Ctrl + H -> the dialog box appears in the section:
- Find What: enter a star and the spacebar.
- Rreplace with section is empty
-> Finally, click Replace All:
Sort the database in Excel Picture 6
Step 3: After clicking Replace All, the result is shown:
Sort the database in Excel Picture 7
Step 4: In cell C9 in the column They enter the formula as shown:
Sort the database in Excel Picture 8
Step 5: Press Enter and make a copy of the formula for the remaining values in the resulting column:
Sort the database in Excel Picture 9
Step 6: Perform copy the entire column They and paste the style Paste Value -> Copy the column They -> paste into the column MI -> press the key combination Ctrl + H -> dialog box that appears in the item:
- Find what: Enter stars and spaces.
- Replace with: Leave blank.
- Finally, click Replace All:
Sort the database in Excel Picture 10
Step 7: Copy and Paste the middle name column as Paste Value. In cell C9 of the column They enter the formula as shown:
Sort the database in Excel Picture 11
Step 8: After pressing Enter -> copy the formula for the remaining values in the resulting column:
Sort the database in Excel Picture 12
Step 9: Make Copy and Paste column They styled Paste Value results:
Sort the database in Excel Picture 13
Step 10: Select the entire data table into Data -> Sort -> dialog box appears enter the values as shown (to add a sort field, click Add Level):
Sort the database in Excel Picture 14
Step 11: After clicking OK, all the data in the table is sorted:
Sort the database in Excel Picture 15
- In case you want to combine 3 columns Last name, Middle name, First name column First and last name perform 3 strings inserting spaces:
Sort the database in Excel Picture 16
- Press Enter -> copy for the remaining values in the column -> Copy the First and Last column and Paste as Paste Value -> delete the 3 columns Last name, Middle name, Result name :
Sort the database in Excel Picture 17
The above is a detailed guide on how to organize a database in Excel 2013.
Good luck!
You should read it
- How to Sort Cells Alphabetically in Excel
- MS Excel 2007 - Lesson 8: Sort and Filter
- Sort data in Excel
- How to sort dates in ascending and descending ways in Excel
- How to Hack a Database
- How to Sort Excel Columns Alphabetically
- How to reverse data in columns on Excel
- How to Create a Database from an Excel Spreadsheet
- How to Sort Microsoft Excel Columns Alphabetically
- How to sort data in Excel Ascending and descending, according to ABC
- Quick Sort (Quick Sort)
- Shell Sort in data structure and algorithm