Antsmarching.org Forums - Dave Matthews Band Discussion - View Single Post - Roger’s Excel Thread
View Single Post
Old 03-03-2006, 11:08 AM   #24
BigE
 
BigE's Avatar
 
Join Date: Feb 2005
Posts: 2,443

Shows Seen: 0

DMB Hub Stubs: 1

My Tour Central Stats

Re: Excel Help

Quote:
Originally Posted by PrettyPenelope
I would try making a copy of the sheet, and save it under another name so it doesn't affect the original. Then do a sort according to whatever column you want, so that all the lines with actual words/numbers will appear together at the top, and the blank lines below. Hope that helps.
Create a reference column with ascending numbers to resort your data by once you've deleted the blanks. Otherwise when you sort your data column it'll put your sequence out of order.
__________________
Quote:
Originally Posted by Hudak-Budak
No cheese or sour cream? Come on, bud...go big or go home. Don't half-ass something as important as seeing how many tacos you can eat before you shit yourself.
BigE is offline   Reply With Quote