Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-25-2011, 02:33 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Column/row reversing in excel Windows 7 32bit Column/row reversing in excel Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default


Here's one easy way: use a temporary helper column.

In a spare column (the "helper" column), type in 1 for the first row, 2 for the second row and then fill it down the column. Then sort the entire data set by that column (largest to smallest), clear the helper column and then you're done.
Attached Images
File Type: png End.png (14.7 KB, 18 views)
Reply With Quote
  #2  
Old 01-26-2011, 12:00 PM
pban92 pban92 is offline Column/row reversing in excel Windows Vista Column/row reversing in excel Office 2003
Novice
Column/row reversing in excel
 
Join Date: Jun 2010
Posts: 7
pban92 is on a distinguished road
Default

That's it! Easy yet efficient! Thanks dude!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Column/row reversing in excel Reverse animation when reversing through slides clients PowerPoint 1 09-28-2010 08:49 PM
Column/row reversing in excel Column width markg67 Word 2 06-07-2010 07:40 PM
Column/row reversing in excel From Excel column to coma saatfj Excel 2 04-15-2010 09:59 PM
Column/row reversing in excel Reversing Text Order weemikey Word 4 08-05-2009 11:10 AM
Column/row reversing in excel Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2026 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft