#1
|
|||
|
|||
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
|
||||
|
||||
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
|
||||
|
||||
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |