|
|
#4
04-06-2014, 03:18 AM
|
||||
|
||||
Hi Kevin,
Interesting approach but, given the OP's 'real' workbook as 100+ columns of data, doubling that number might make the workbook rather unwieldy. Plus it still doesn't sort the data - it just gives a ranked report of them. It that were all that's required, I'd be inclined to use a separate worksheet and arrange the data in a single column.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| data, probz, sorting |
| Thread Tools | |
| Display Modes | |
|
|
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 7 32bit 
Office 2010 32bit
Threaded Mode