|
|
#1
08-23-2015, 03:02 AM
|
|||
|
|||
Sorting large amounts of data based on multiple columns
Hi all,
Hoping you can help. I have a very large dataset that i need to be able to sort all at once as it would take a very long time to move it all around manually. I have attached a sample of the data for you to have a play with. Sheet 1 is the raw data and sheet 2 is how i would like it to appear (sorted by various columns of dates) as you will see doing this by hand will take an extremely long time, i am hopeful that someone can give me a point in the right directions. Any help you can offer will be much appreciated. Many Thanks Mac 
|
|
#2
08-23-2015, 09:54 AM
|
||||
|
||||
|
Cross post without links http://www.excelforum.com/excel-gene...e-dataset.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
08-23-2015, 10:26 PM
|
||||
|
||||
|
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
| Need help sorting data in columns that will sort by number of Xs | brenna.at.work | Excel | 8 | 04-12-2014 07:00 AM |
 Vlookup help for large amounts of stock data
|
jyfuller | Excel | 15 | 09-21-2012 11:35 AM |
| Can I do this? sorting data in seperate columns | shumonsaha | Excel | 0 | 07-04-2010 03:05 AM |
| CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. | psmaster@earthlink.net | Excel | 0 | 11-24-2009 11:54 AM |
Windows 7 32bit 
Office 2007
Linear Mode
