Everybody plays each other. That's all anybody ever does. We play parts.

Saffron ,'Our Mrs. Reynolds'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


Tom Scola - Aug 07, 2007 8:50:43 am PDT #2355 of 25496
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

Not yet, but it's still happening.


Jessica - Aug 07, 2007 9:01:13 am PDT #2356 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Holy shit, they replaced iMovie.

About damn time, too. Though from the description in that blog I can't tell if they've replaced it with something better or worse.


beekaytee - Aug 07, 2007 9:07:52 am PDT #2357 of 25496
Compassionately intolerant

Oooh. Cool new Apple stuff. My favorite geek porn.

Excel question:
I've never been, nor shall I ever be, Excel-lent with spreadsheets or databases. But I really NEED a contact database to use with my autoresponder and email communications.

So. I put together a spreadsheet that includes 385 names...email first, fname, lname, some segment categories, address, etc.

The problem is, I dumped the data from a bunch of different resources and it is in no particular order.

I would like to sort by last name and keep the records together, but that doesn't seem possible.

Am I a complete idiot? The sort function keeps telling me that my cells have to be the same size.

I'm confuzzled.


Tom Scola - Aug 07, 2007 9:16:22 am PDT #2358 of 25496
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.

...And Apple just introduced a new spreadsheet app.


amych - Aug 07, 2007 9:19:50 am PDT #2359 of 25496
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?

...And Apple just introduced a new spreadsheet app.

about damn time.


beekaytee - Aug 07, 2007 9:23:16 am PDT #2360 of 25496
Compassionately intolerant

Will it import an excel spreadsheet and let me sort by record?


§ ita § - Aug 07, 2007 9:25:55 am PDT #2361 of 25496
Well not canonically, no, but this is transformative fiction.

Excel's not for records. Access is for records.

I know, I know--that ship has sailed and it's a de facto database for many people, but it's so damned broken that way I've given up on trying to fix it with shoestrings and ceiling wax.


Sophia Brooks - Aug 07, 2007 9:30:26 am PDT #2362 of 25496
Cats to become a rabbit should gather immediately now here

The problem with Access is that when you open it up, as a person who jsut wants to do a mail merge, it is very confusing. Most people at my job just actually TYPE ALL THEIR MAILING LISTS DIRECTLY ONTO LABELS IN WORD and then HAND PICK THROUGH THEM TO MAIL THE ITEMS or merge to lists. So, using excel is an improvement, I think.

I am not sure I understand why it needs your cells to be all one size, or why they wouldn't be. I feel like I could probably fix it if you emailed it to me...


tommyrot - Aug 07, 2007 9:31:49 am PDT #2363 of 25496
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

You can sort "by record" in Excel - just select the entire range of stuff you want sorted and use the sort function (under the Data menu).

The sort function keeps telling me that my cells have to be the same size.

OK, I don't understand what's going on here.


Jessica - Aug 07, 2007 9:35:06 am PDT #2364 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

Beej, you probably have some merged cells in the list you're trying to sort.