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.
'Unleashed'
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!
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.
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.
Any Excel gurus in da hizouse? Excel's Help function is of the suck.
Watcha need?
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.
You could create a column for month (use the MONTH function) and then create a pivot table that sorts by month.
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".
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.
Awright. I did the MONTH thing, and it worked. Thanks.
It just seems like you should be able to tell the damn thing "Look, the date is 2/something/2007. Just look for all the 2/somethings and give me the February total without me having to add a whole other column."
Razzafrazzin' new-fangled difference engines...