How to Sort Data by Last Name/Month/Frequency/Text Length in Excel?
Tags: kutoolsexceltutorial, sortdatainexceloffic, kutools
Published: 2020-11-16 07:31:00

---
title: How to Sort Data by Last Name/Month/Frequency/Text Length in Excel?
published: true
date: 2020-11-15 15:44:00 UTC
tags: KutoolsExcelTutorial,SortDatainExcelOffic,Kutools
canonical_url: https://geekexcel.com/how-to-sort-data-by-last-name-month-frequency-text-length-in-excel/
---

In this article, you will understand the steps to **Sort Data by Last Name/Month/Frequency/Text Length in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Sort Data by Last Name:

If you want to sort the list of names by the last name, follow the below steps.

- First, you need to **select the input range** that you want to sort.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-16.png)<figcaption id="caption-attachment-17183">Select the range</figcaption>

- On the **Kutools Plus Tab, select** the **Sort** option, **choose** the **Advanced Sort** option from the menu.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will open the **Advanced Sort Dialog Box**.
- In that dialog box, you need to **check** the **My data has headers** option.
- **Column Drop-down list –** You need to **choose the column** that you want to sort.
- **Sort On Drop-down list – Select** the **Last name** option.
- Finally, **choose** the **Sort Order.**

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-15.png)<figcaption id="caption-attachment-17184">Click OK button</figcaption>

- After completing the above steps, **click** the **OK** button. You can see the data has been sorted by the last name as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-12.png)<figcaption id="caption-attachment-17185">Result</figcaption>

## Steps to Sort Data by Text Length:

To sort the input text strings by their length, do as follows.

- You need to **select the range of text strings** that you want to sort.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-10.png)<figcaption id="caption-attachment-17186">Input Range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Sort** option, **choose** the **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will display the **Advanced Sort Dialog Box**.
- **Column Drop-down list –** You need to **choose the column** that you want to sort.
- **Sort On Drop-down list – **** Select **the** Text length** option.
- Then, **select** the **sort order** as you need.
- If there are headers in your selection, kindly **check** the **My data has headers** option.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-10.png)<figcaption id="caption-attachment-17187">Click OK button</figcaption>

- Finally, **hit** the **Ok** button. You can see the data has been sorted by the character length as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-8.png)<figcaption id="caption-attachment-17188">Output</figcaption>

## Sort Data by Day/Week/Month/Quarter in Excel:

Generally, we sort the date values by the year. If you want to sort the dates by the day/week/month or quarter, do as follows.

- You need to **select the range**  that you want to sort.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-8.png)<figcaption id="caption-attachment-17189">Select the range</figcaption>

- Go to the **Kutools Plus Tab, select** the **Sort** option, **choose** the **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will display the **Advanced Sort Dialog Box**.
- **Column Drop-down list –** You need to **choose the column** that you want to sort.
- **Sort On Drop-down list – **** Select **the** Day, Month, Week, **or** Quarter**that you need to sort (here we choose the**month** option).
- Please **check** the **My data has headers** option if your selection has headers.

![Advanced Sort Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-6.png)<figcaption id="caption-attachment-17190">Advanced Sort Dialog Box</figcaption>

- Then, **click** the **OK** button to sort the rows.
- You can see that the selected data has been sorted by the month as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-6.png)<figcaption id="caption-attachment-17191">Output</figcaption>

## Steps to Sort Data by Absolute Value:

To sort data by [absolute](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) values in Excel, do as follows.

- You need to **select the data range** that you want to sort.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-4.png)<figcaption id="caption-attachment-17192">Input Range</figcaption>

- Next, on the **Kutools Plus Tab, select** the **Sort** option, choose the  **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will display the **Advanced Sort Dialog Box**.
- **Column – Select** the **column** which you want to sort.
- **Sort On –** Here, you need to **choose** the **[Absolute](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) value** option.
- If your input range has headers, then you need to check the **My data has herders** option.

![Select the Absolute Value option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-4.png)<figcaption id="caption-attachment-17193">Select the Absolute Value option</figcaption>

- Finally, **hit** the **OK** button.
- Now, you will see all the numbers have been sorted by the absolute values as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-3.png)<figcaption id="caption-attachment-17194">Result</figcaption>

## Sort Data by Odd & Even Numbers:

With the help of Kutools, you can sort all the odd numbers followed by the even numbers from the list of numbers. Do as below instructions.

- You need to **select the data range** that you want to sort.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-3.png)<figcaption id="caption-attachment-17195">Select the range</figcaption>

- On the **Kutools Plus Tab, select** the **Sort** option, choose the **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will display the **Advanced Sort Dialog Box**.
- **Column drop-down list – Select** the **column** which you want to sort.
- **Sort On drop-down list –**  **Choose** the **Odd and even number** option.
- If there are headers in your selection, you need to **select** the **My data has headers** option.
- Then, **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-3.png)<figcaption id="caption-attachment-17196">Click OK button</figcaption>

- After clicking the **OK** button, you will see the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16-2.png)<figcaption id="caption-attachment-17197">Result</figcaption>

### Note:

- If you want to **sort the odd numbers** first and **followed by the even numbers** , **select** the **Z to A** option under the **Order** section.

## Steps to Sort Data by Email Domain Name:

If you want to sort data by email domain name, do as follows.

- You need to **select the data range** that you want to sort.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/17-2.png)<figcaption id="caption-attachment-17198">Input range</figcaption>

- On the **Kutools Plus Tab, select** the **Sort** option, choose the **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- It will display the **Advanced Sort Dialog Box**.
- **Column drop-down list – Select** the **column** which you want to sort.
- **Sort On drop-down list –**  **Choose** the **Mail domain** option.
- Then, select the sort **order** as you wish.
- If there are headers in your selection, you need to **select** the **My data has headers** option.

![Hit the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/18-2.png)<figcaption id="caption-attachment-17199">Hit the OK button</figcaption>

- Finally, **click** the **OK** button.
- Now, you will see all the email addresses have been sorted by the domain name as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/19-2.png)<figcaption id="caption-attachment-17200">Output</figcaption>

## Sort Data By Frequency/Occurrence in Excel:

If you want to sort data by occurrences of the value, please do as follows.

- You need to **select the data range** that you want to sort.

![Input range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/20-2.png)<figcaption id="caption-attachment-17201">Input range</figcaption>

- On the **Kutools Plus Tab, select** the  **Sort** option, choose the **Advanced Sort** option from the menu list.

![Select the Advanced Sort option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-16.png)<figcaption id="caption-attachment-17182">Select the Advanced Sort option</figcaption>

- Then, it will display the **Advanced Sort Dialog Box**.
- **Column drop-down list – Select** the **column** which you want to sort.
- **Sort On drop-down list –** You need to **c**** hoose **the** Frequency** option.
- You need to **select the sort order** as you want.
- If your input range has headers, then you need to check the **My data has herders** option.
- Finally, **hit** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/21-1.png)<figcaption id="caption-attachment-17202">Click OK button</figcaption>

- Now, you will see the data that has been sorted by the frequency of each item from the range as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/22-1.png)<figcaption id="caption-attachment-17203">Output</figcaption>

## End of the Article:

In this article, you can clearly understand the steps to **Sort Data by Last Name/Month/Frequency/Text Length in Excel Office 365** using **Kutools. ** Don’t forget to share your worthwhile **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Print Only Specific, Even or Odd Pages in Excel Office 365](https://geekexcel.com/how-to-print-only-specific-even-or-odd-pages-in-excel-office-365/)
- [How to Freeze Panes Across Multiple Worksheets in Excel Office 365?](https://geekexcel.com/how-to-freeze-panes-across-multiple-worksheets-in-excel-office-365/)