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,386
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 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, 10 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 10:58 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