+ Reply to Thread
Results 1 to 3 of 3

Need Help Sorting Table based on a Column Value in Excel 2007

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need Help Sorting Table based on a Column Value in Excel 2007

    I am working in a table with 14 columns and 1624 rows. When I sort based on a specific column, only half my table is sorted. The other half remains in place, which renders the function useless to my needs.

    Does anyone have any suggestions on how to overcome this issue?

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Need Help Sorting Table based on a Column Value in Excel 2007

    Hi

    Could be casued by blank cells or corupt data.

    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    10-02-2012
    Location
    Baku
    MS-Off Ver
    Excel 2010
    Posts
    273

    Re: Need Help Sorting Table based on a Column Value in Excel 2007

    According to my experience , If the column names are in filter and when you sort those columns, unfiltered columns do not change with others.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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