Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-26-2019, 01:21 AM
emvella emvella is offline Windows XP Office 2007
Novice
 
Join Date: Sep 2009
Posts: 6
emvella is on a distinguished road
Default Sort by Columns

Hi,


I copy from a website and paste in excel like the sheet that I just posted. I don't know if it is possible or not. What I want is that I Sort the list by column B (time) but because each game is in 2 rows then I cannot do it because I am having a mess.



Thanks

Last edited by emvella; 02-26-2019 at 06:11 AM. Reason: Removed links
Reply With Quote
  #2  
Old 02-26-2019, 04:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
please post on the forum (a sheet, please, no pictures). External links are notoriously unsafe and not accessible to everyone.
Thanks
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 02-26-2019, 05:41 AM
emvella emvella is offline Windows XP Office 2007
Novice
 
Join Date: Sep 2009
Posts: 6
emvella is on a distinguished road
Default

Ok, I just posted a sheet.
Reply With Quote
  #4  
Old 02-26-2019, 05:45 AM
emvella emvella is offline Windows XP Office 2007
Novice
 
Join Date: Sep 2009
Posts: 6
emvella is on a distinguished road
Default

Here is the sheet
Attached Files
File Type: xls Sort by Columns.xls (25.0 KB, 5 views)
Reply With Quote
  #5  
Old 02-26-2019, 06:18 AM
emvella emvella is offline Windows XP Office 2007
Novice
 
Join Date: Sep 2009
Posts: 6
emvella is on a distinguished road
Default

I want it to be sorted like this:
Attached Files
File Type: xls Sort by Columns (sorted).xls (25.5 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort multiple columns with pages thumb Excel 60 08-29-2018 10:56 AM
Macro to sort columns SerenityNetworks Excel Programming 4 09-02-2016 06:20 AM
.pdf to .xlsx - How to get sort-able columns? CCinPA Excel 0 07-05-2016 08:30 AM
How to sort table having three columns? Bahir Barak Word 2 01-20-2011 01:52 PM


All times are GMT -7. The time now is 06:01 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft