What you did to me was unbelievable, Connor. But then I got stuck in a hell dimension by my girlfriend one time for a hundred years, so three months under the ocean actually gave me perspective. Kind of a M.C. Escher perspective, but I did get time to think.

Angel ,'Conviction (1)'


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!


Ginger - Dec 05, 2007 11:11:15 am PST #3685 of 25497
"It didn't taste good. It tasted soooo horrible. It tasted like....a vodka martini." - Matilda

This is really clunky and inelegant, but I finally ended up syncing both computers to the external drive I use for backup. Both computers will talk to the external hard drive, but my rather elderly laptop will not talk to my desktop, no matter what cable I try. It's like a bad marriage in which people only communicate through their children.

What about just getting a large capacity thumb drive and transferring the files that way? Of course, that would mean you'd have to set up the desktop in some fashion to transfer the files.


Gudanov - Dec 05, 2007 12:10:45 pm PST #3686 of 25497
Coding and Sleeping

Do you have a router to connect to the Internet? Hooking up the two through a router will be a lot easier than connecting them directly.


Vortex - Dec 05, 2007 2:20:03 pm PST #3687 of 25497
"Cry havoc and let slip the boobs of war!" -- Miracleman

basically, I'm trying to avoid setting up the desktop. I was hoping that I could just connect the laptop to it in some way and transfer the files, like using the desktop like a giant external drive.


omnis_audis - Dec 05, 2007 10:09:18 pm PST #3688 of 25497
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

Hey iPhone & iTouch users. Looks like google is stepping it up for us. [link]

I was just playing with mobile.google.com, and it is pretty cool. A bit zippier. Clearly not loading as much junk. Thought I'd share.


Miracleman - Dec 06, 2007 5:25:29 am PST #3689 of 25497
No, I don't think I will - me, quoting Captain Steve Rogers, to all of 2020

Any Excel gurus in da hizouse? Excel's Help function is of the suck.


tommyrot - Dec 06, 2007 5:28:15 am PST #3690 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Watcha need?


Miracleman - Dec 06, 2007 5:38:06 am PST #3691 of 25497
No, I don't think I will - me, quoting Captain Steve Rogers, to all of 2020

What I'm trying to do is calculate some expenses and get a variety of totals. An array formula is doing great with the type of thing the money is spent on, but I can't figure out how to get Excel to also total it by month. I have a column for "Order Date" and it has the specific date e.g. 2/12/2007, but I can't get an array to give me a value for, say, all the orders in February.


Jon B. - Dec 06, 2007 5:40:38 am PST #3692 of 25497
A turkey in every toilet -- only in America!

You could create a column for month (use the MONTH function) and then create a pivot table that sorts by month.


Miracleman - Dec 06, 2007 5:43:14 am PST #3693 of 25497
No, I don't think I will - me, quoting Captain Steve Rogers, to all of 2020

I don't want a table. I just want it to go through the list and say "Oh, that cell has 2/whatever day/2007. That means it is in February. I will go to column F, where the amount for that order is, and include that in my calculation. Then, in the specified cell, I will total all the cells that say 2/some day/2007".


tommyrot - Dec 06, 2007 5:43:44 am PST #3694 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

I'd add an extra column for the month, and use the MONTH function on the order date. This will give you a number from 1-12. Then have Excel do subtotals based on the month.

eta: x-posty.