+ Reply to Thread
Results 1 to 2 of 2

Getting 15 columns in a spreadsheet to sort on one the columns as it alphabetzes

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Getting 15 columns in a spreadsheet to sort on one the columns as it alphabetzes

    Have a spreadsheet with 15 columns. In one of the columns is the name of the company and that column is not in alphabetical order. The city, state, zip code, business type and all the other pertinent data about that company is in the same row as the name of the company. My intent would be to put the company names in alphabetical order and keep all the company information in the same row as the company name.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Getting 15 columns in a spreadsheet to sort on one the columns as it alphabetzes

    This sounds like a basic sort function which can be found on the <Data> tab. If this is not the case, please attach a copy of your workbook so we can see what the problem is. Remember to remove/replace any sensitive info before uploading.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Replies: 1
    Last Post: 11-06-2012, 07:07 PM
  2. Ability to sort by Sheet, Columns, Within those columns, and Operations on Info
    By TopC1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-22-2010, 10:43 AM
  3. [SOLVED] How do I sort or compare data from 2 different spreadsheet columns
    By bectayers in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-01-2006, 01:45 PM
  4. How to sort an Excel spreadsheet by more than 3 columns?
    By William,Summit,Oh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-28-2005, 12:35 PM
  5. Replies: 1
    Last Post: 11-27-2005, 12:15 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