I am forgoing mani/pedis and meals out to budget for the magicphonesparklyness.
Fred: The size and depth of the wound indicate a female vampire. Harmony: Or gay! Fred: Um…it doesn't really work like that.
'Harm's Way'
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!
javachik - Jul 21, 2010 12:59:01 pm PDT #14491 of 25501
Our wings are not tired.
Jessica - Jul 21, 2010 1:40:26 pm PDT #14492 of 25501
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Even with a Sansa clip, I'd have no way to get the files from the Internet to the device since Overdrive for Mac only recognizes mp3s.
Jon B. - Jul 21, 2010 4:06:06 pm PDT #14493 of 25501
A turkey in every toilet -- only in America!
What's the formula that I need to search a row to find out if any value contains a certain character? Not is equal to, but contains? I need to scan a range for "|", and I can't work out the simplest way. Everything I can think of is unduly convoluted.
I think writing a quick macro using the Find method will work, but maybe that counts as convoluted? [link]
§ ita § - Jul 21, 2010 4:12:08 pm PDT #14494 of 25501
Well not canonically, no, but this is transformative fiction.
Yeah, that counts as convoluted. I'll just go back to the SQL or something. I hate data.
Thanks, though.
le nubian - Jul 21, 2010 4:28:12 pm PDT #14495 of 25501
"And to be clear, I am the hell. And the high water."
§ ita § - Jul 21, 2010 4:31:22 pm PDT #14496 of 25501
Well not canonically, no, but this is transformative fiction.
The problem is I need to search a range (most of a row), not a cell. That's what's tripping me up. I guess I could concatenate those cells first--it's just dragging the formulas, in the end.
Thanks.
le nubian - Jul 21, 2010 4:38:45 pm PDT #14497 of 25501
"And to be clear, I am the hell. And the high water."
oh, I see. how many cells are in the row, roughly?
§ ita § - Jul 21, 2010 4:59:20 pm PDT #14498 of 25501
Well not canonically, no, but this is transformative fiction.
Fifteen or so?
le nubian - Jul 21, 2010 5:25:52 pm PDT #14499 of 25501
"And to be clear, I am the hell. And the high water."
ita, can you import the document into google docs? there are Hlookup commands and vlookup commands that should be able to do what you want.
§ ita § - Jul 21, 2010 5:59:25 pm PDT #14500 of 25501
Well not canonically, no, but this is transformative fiction.
Hello? Why am I not using hlookup? I use vlookup all the time.
I will get on that tomorrow.