Does anybody here have a Lynda.com membership that allows you to download exercise files? I could really use the one for Practical & Effective JavaScript if so....
I'm just trying to tell you that we have nothing in common besides both of us liking your penis.
Anya ,'Dirty Girls'
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!
Theodosia - Jan 28, 2014 9:25:52 am PST #23604 of 25496
'we all walk this earth feeling we are frauds. The trick is to be grateful and hope the caper doesn't end any time soon"
Jessica - Jan 28, 2014 9:56:01 am PST #23605 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Theo, email me.
Hil R. - Jan 28, 2014 10:10:46 am PST #23606 of 25496
Sometimes I think I might just move up to Vermont, open a bookstore or a vegan restaurant. Adam Schlesinger, z''l
One of the jobs where I'm applying wants a video of me teaching. I had one of my friends video my class yesterday, on my iPad. I just tried to post the video to YouTube, from the iPad, and the iPad just froze. Touching the screen doesn't do anything. Pressing the square button gets me back to the home screen. The video did not post to YouTube. I tried iCloud, and same thing happened. Any suggestions?
Hil R. - Jan 28, 2014 10:15:42 am PST #23607 of 25496
Sometimes I think I might just move up to Vermont, open a bookstore or a vegan restaurant. Adam Schlesinger, z''l
OK, wait, it seems that, if I just leave it alone after it freezes, then eventually, it starts uploading.
sumi - Jan 29, 2014 7:07:31 am PST #23608 of 25496
Art Crawl!!!
Le nubian - it turns out that the university library has an e-book and a physical book that my boss can use.
Jessica - Jan 29, 2014 8:22:17 am PST #23609 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I have a complicated Excel question.
I have a multi-tabbed spreadsheet. Each tab is sorted by archive and has a subtotal indicating how many seconds from that archive we've sold. What I want is a summary sheet which adds up all the subtotals.
Is there a formula which will look for "News Subtotal" in each tab and then take the number in the cell next to it? I feel like SUMIF should do this but I don't know how it works.
SuziQ - Jan 29, 2014 8:23:45 am PST #23610 of 25496
Back tattoos of the mother is that you are absolutely right - Ame
Depending on how your spreadsheets are set-up, what about vlookup? Or hlookup is it is a horizontal field.
meara - Jan 29, 2014 8:28:51 am PST #23611 of 25496
Does the cell #/location not stay the same in each tab (ie, does Tab1 move the News Subtotal from H100 to H101 depending on what's going on), and that's why you need it to be next to the "News Subtotal"?
Jessica - Jan 29, 2014 9:27:13 am PST #23612 of 25496
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Yeah, each tab has a completely different number of rows, and in some cases columns. So what I need is to take all of the subtotal rows and transfer them to a clean sheet so I can add up those values.
meara - Jan 29, 2014 9:38:01 am PST #23613 of 25496
Sorry, I mean when the spreadsheet is updated, does the placement of the value change within the tab? Not that in Tab1 it's H100 and Tab2 it's G75, but like, on Monday Tab1 is H100 and Friday it's Tab1 H106?
Because if it's just in a different place in each tab, that's easy enough. If it changes where it is, different task.