Page 1 of 2
Some spreadsheet help
Posted: Mon Jul 17, 2006 3:21 am
by AYHJA
I have a spreadsheet, and I want to flip the order of a sheet...
For example, the sheet looks like this:
5
4
3
2
1
and I want to make it so that 1, and the adjacent columns simply go to the top of the sheet, and 2 follows right behind it and so on and so on...Any suggestions..?
Posted: Mon Jul 17, 2006 4:50 am
by Brains
use tools, sort.
Posted: Mon Jul 17, 2006 7:20 am
by AYHJA
I tried that, maybe I am doing something wrong, have a hack at it... /:D" style="vertical-align:middle" emoid=":D" border="0" alt=":D" />
http://www.ayhja.us/downloads/SetListing.rar
Posted: Mon Jul 17, 2006 7:40 am
by Bot
The closests I could get it is sorting it by release date. That's kind of retarded how it goes 1, 100, 101, 102, 103 etc...
Posted: Mon Jul 17, 2006 8:17 am
by Brains
ah. we could have discussed for hours if you would not have shared the book.
problem is that you should not really store text and numbers in Excel
i split them. you can sort now. /wink.gif" style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />
Posted: Mon Jul 17, 2006 8:33 am
by AYHJA
raum is going to be pissed I had an excel question and he didn't get to write a discourse on it...Hahaha...Thanks Brains...
Posted: Mon Jul 17, 2006 8:34 am
by AYHJA
He'll be pleased to know tho, that the release date column was f0xx0red in the process....
But not your fault, I think the dates got screwed when I saved off the Open Office format I was using...
Posted: Mon Jul 17, 2006 9:05 am
by Brains
nononono!!!! i wouldn't do such a thing. they are just in Excel's number format. select the column, right click, format cells, pick "date" and you're set.
but yesyesyes. it could have well got something to do with the openoffice thing.
ah raum is good at excel as well. great. some thing we have in common - in stark contrast to our political views.
Posted: Mon Jul 17, 2006 2:39 pm
by raum
I made a new format, that has limited data validation, and identified some errors.
I did a integrity analysis of your index, and noticed Set 70, 72, 169, 172 and 175 were not in serial order. other than that, this will fit your need, and is a much better model for your data, which can sort by year, day, month, index number, and even which sets have names.
So, let me know if you want it.
and yes, Brains, I LOVE EXCEL. and need to learn more vba. I use excel at least 6 hours a day.
Posted: Mon Jul 17, 2006 4:14 pm
by WAY
FREAK..! lol
Oh, raum, how many Excel sheets you got with VBS..? I need them to test OpenOffice.org's VBA interpreter.. lol (or, if you want to.. lol)