+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Excel 2010 Sorting data in Technical; Hi, Happy new year to you all I have a quick excel question, i have a sheet that has name,reg ...
  1. #1
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    554
    Thank Post
    105
    Thanked 23 Times in 21 Posts
    Rep Power
    17

    Excel 2010 Sorting data

    Hi, Happy new year to you all

    I have a quick excel question, i have a sheet that has name,reg group, attendance1,attendance2 colums.

    problem i have is that when i sort it one of the attendance colums doesnt sort right it doesnt order the colum highest to lowest, i need it to order attendance 1 and 2 highest to lowest while keeping the names and reg group matched to the attendnace data

    Thanks

    Mark

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,403
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    168
    If the two attendance columns are numeric then surely only the first one sorted will be in descending order? If Excel tried to sort the second column also then the first one would then be out of order.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2007] Excel Does Not Display Data In Spreadsheet
    By DaveP in forum Office Software
    Replies: 2
    Last Post: 30th November 2012, 04:24 PM
  2. Excel sorting advice
    By rocknrollstar in forum Windows
    Replies: 7
    Last Post: 28th July 2009, 11:47 AM
  3. Merging data in excel
    By Mr_M_Cox in forum Windows
    Replies: 10
    Last Post: 31st October 2008, 11:43 AM
  4. Sorting levels in Excel - eg 2a 2b 2c
    By rocknrollstar in forum Office Software
    Replies: 4
    Last Post: 15th September 2008, 07:21 PM
  5. Excel Assesment Data
    By danIT in forum General Chat
    Replies: 2
    Last Post: 14th February 2008, 02:14 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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