+ Reply to Thread
Results 1 to 3 of 3

Sorting Columns

  1. #1
    Registered User
    Join Date
    01-19-2015
    Location
    Portland Oregon
    MS-Off Ver
    2011
    Posts
    28

    Sorting Columns

    How do I sort column C alphabetically and make sure the other 2 columns sort in the same order?

    Thank you in advance

    A B C
    EPID MPN BRAND
    74278450 3311 Bosch
    74277160 022-1620 Beck/Arnley
    74276930 C0652 Silla Cooling System
    74277680 SW906 Wells
    74278480 FPS136 DNJ Engine Components
    74277920 21817 iSeal
    74277440 EGR1834 BWD Automotive
    74276580 EGR1651 BWD Automotive
    74278730 40018 Goodyear Engineered Products
    74276520 DLK599L BWD Automotive
    74277080 7105 Silla Cooling System
    74276630 061-9112 Beck/Arnley
    74278670 S2068 BWD Automotive
    74278790 B3162 Pitstop
    74277350 50035 Haynes Publications
    74278440 3950 Ready-Aire
    74277420 CF5247 Service Champ

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Sorting Columns

    Just click a cell in your table and go to Data->Sort. That should highlight your data and bring up a dialog box. Choose Brand in the Sort By drop down and hit OK.

    FYI, while answering questions in the forum is what we do, for something like this you may get more immediate answers by just googling (e.g. 'sort data in excel').
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Sorting Columns

    Hi,
    Select all Data.
    Go to Data > Sort
    Sort by: Select "Brand", Sort on = Values, Order = "A to z"
    Click ok
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sorting columns based on row criteria, with variable number of columns
    By bardobhb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-02-2014, 04:02 PM
  2. Replies: 0
    Last Post: 05-15-2013, 09:18 AM
  3. Replies: 3
    Last Post: 06-09-2011, 05:58 AM
  4. sorting two columns and write the sorted values on two columns in a different sheet
    By virsojour in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-22-2010, 04:38 AM
  5. Sorting groups of columns to a related group of columns
    By fuadramsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2007, 07:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1