Death is your art. You make it with your hands day after day. That final gasp, that look of peace. And part of you is desperate to know: What's it like? Where does it lead you? And now you see, that's the secret. Not the punch you didn't throw or the kicks you didn't land. She really wanted it. Every Slayer has a death wish. Even you.

Spike ,'Conversations with Dead People'


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!


NoiseDesign - Jul 21, 2010 12:24:49 pm PDT #14489 of 25501
Our wings are not tired

I want an iPhone 4 very badly.


amych - Jul 21, 2010 12:26:46 pm PDT #14490 of 25501
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?

javachik, MAGICAL SPARKLEPONIES


javachik - Jul 21, 2010 12:59:01 pm PDT #14491 of 25501
Our wings are not tired.

I am forgoing mani/pedis and meals out to budget for the magicphonesparklyness.


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, do you still need to know?

would this work?

[link]


§ 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?