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 ...
31st December 2010, 11:30 AM #1
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
IDG Tech News
31st December 2010, 01:04 PM #2
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.
By DaveP in forum Office Software
Last Post: 30th November 2012, 05:24 PM
By rocknrollstar in forum Windows
Last Post: 28th July 2009, 12:47 PM
By Mr_M_Cox in forum Windows
Last Post: 31st October 2008, 12:43 PM
By rocknrollstar in forum Office Software
Last Post: 15th September 2008, 08:21 PM
By danIT in forum General Chat
Last Post: 14th February 2008, 03:14 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)