1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Sort by 2 Columns in Excel 2016

Discussion in 'Programming' started by jaguar34, Dec 24, 2022.

  1. #1
    I want to sort the keyword research data which is huge like 2500+ keywords. I want to sort the data in Excel 2016 by 2 Columns. How to do it?
     
    jaguar34, Dec 24, 2022 IP
    sottystart likes this.
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,494
    Likes Received:
    4,457
    Best Answers:
    123
    Trophy Points:
    665
    #2
    Can we see what your data looks like? You say "THE keyword research data" as if we should all know what you're talking about. What is stopping you dong a regular sort?
     
    sarahk, Dec 25, 2022 IP
  3. saramar

    saramar Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    To sort data in Excel 2016 by two columns, follow these steps:

    1. Select the range of cells that you want to sort.

    2. On the "Home" tab, click the "Sort & Filter" button.

    3. From the dropdown menu, select "Custom Sort".

    4. In the "Sort dialog box", select the first column that you want to sort by in the "Sort by" dropdown menu.

    5. In the "Then by" dropdown menu, select the second column that you want to sort by.

    6. Use the "Order" dropdown menus to specify the sort order for each column (ascending or descending).

    7. Click the "OK" button to sort the data by the two selected columns.
     
    saramar, Jan 3, 2023 IP
  4. saramar

    saramar Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    Alternatively, you can use the following formula to sort the data by two columns:

    1. Select a cell in the row below the column headings.

    2. Type the following formula:
    =SORT(A2:C10, 1, TRUE, 2, TRUE)
     
    saramar, Jan 3, 2023 IP
  5. ChristianMorris

    ChristianMorris Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #5
    To sort data in Excel by multiple columns:

    1. Select the cells in the range of data you want to sort.
    2. Click the "Sort & Filter" button in the Editing group on the Home tab.
    3. Click "Sort Oldest to Newest" or "Sort A to Z" to sort by the first column.
    4. Click "Add Level" and select the second column you want to sort by.
    5. Choose whether you want to sort the second column in ascending or descending order.
    6. Click "OK" to sort the data.
    Alternatively, you can use the "Sort" button in the Data tab of the ribbon. This will give you the option to sort by multiple columns at once.

    You can also use the "Sort" dialog box to specify the sort criteria, sort order and the range of cells to be sorted.
     
    ChristianMorris, Jan 22, 2023 IP