|
|
|
|
#1
04-06-2014, 01:51 AM
|
|||
|
|||
Perhaps something along these lines using a helper row. In this case I have the helper row in J3:P3 and formatted as ";;;" (Without the double quotes) to hide the helper row.
The formula in J1 is an array formula and copied across. 
|
|
| Tags |
| data, probz, sorting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Cannot Convert Text Cell to number format to be able to sort the data
|
jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
|
How to sort table having three columns?
|
Bahir Barak | Word | 2 | 01-20-2011 01:52 PM |
| 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 |
| Sorting columns in Excel - please advise | Jonre | Excel | 2 | 08-21-2009 02:38 AM |
Windows 8 
Office 2013
Hybrid Mode