Buffy: How was school today? Dawn: The usual. A big square building filled with boredom and despair. Buffy: Just how I remember it.

'The Killer In Me'


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!


flea - Jun 23, 2009 2:30:48 am PDT #10530 of 25501
information libertarian

I read this as "underwear cameras." I think I need more coffee.


Gudanov - Jun 23, 2009 4:38:39 am PDT #10531 of 25501
Coding and Sleeping

I read this as "underwear cameras."

Now there's a Flickr photostream I never want to see.


brenda m - Jun 23, 2009 6:18:35 am PDT #10532 of 25501
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there

Excel question - if someone set up a workbook and spaced all their content by including an extra row between each item, is there a simple way to get rid of those empty rows other than deleting one by one?


tommyrot - Jun 23, 2009 6:20:49 am PDT #10533 of 25501
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Can you do a sort (forcing all the spaces to either the beginning or end)?


brenda m - Jun 23, 2009 6:26:52 am PDT #10534 of 25501
If you're going through hell/keep on going/don't slow down/keep your fear from showing/you might be gone/'fore the devil even knows you're there

The cells with actual input don't follow any sortable pattern so I think I'd end up with a bigger mess than I have, unfortunately. Maybe I'll play with that a little and see if I can figure out a workaround.


Kristen - Jun 23, 2009 7:03:41 am PDT #10535 of 25501

Excel question - if someone set up a workbook and spaced all their content by including an extra row between each item, is there a simple way to get rid of those empty rows other than deleting one by one?

You can select multiple rows by holding down CTRL as you click the start of each blank row. Then you can delete them all at once.

Or, depending on what you're doing with the spreadsheet, you could cheat. Turn on Filter and filter out the blanks.

ETA: I also have a solution that involves IF statements, if you need it.


Jon B. - Jun 23, 2009 7:15:40 am PDT #10536 of 25501
A turkey in every toilet -- only in America!

Or, create a new column with a formula like (assume this example is in row 3): =if(a3="","",row(a3)) That'll put the row number in all rows that aren't blank. Copy/Paste Value this column, then sort by it. That'll keep the order the same, but put all the blanks together.


Typo Boy - Jun 23, 2009 9:01:52 am PDT #10537 of 25501
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

John McGrath, an email acquaintence who posts on Dymaxion Blog and who is one of the good guys (and who really ought to be a Buffista) has had a disasterous data loss while working a project for his masters: [link]

I'm working on a large article as my final assignment for my Master's degree, which has to date involved at least 5 hours of interviews with some pretty interesting people.

Last night I was consolidating the files scattered across three different hard drives when the USB drive I was using decided to cack out on me. I have, it seems, lost all of the recordings of my interviews.

Gun in mouth ---> pull trigger.

Man, I fucking hate computers. Anyone know a good service that can recover data from a corrupted USB drive?

If anyone wants to help him out either by commenting on the post linked, or by posting here... Cause google shows lots of data recovery services out there, and I suspect someone on this board knows who the good ones are.


le nubian - Jun 23, 2009 10:02:48 am PDT #10538 of 25501
"And to be clear, I am the hell. And the high water."

there's a good one in Canada that I know people have used and is successful.

it is not cheap.


Typo Boy - Jun 23, 2009 10:04:07 am PDT #10539 of 25501
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.

I suspect at this point good beats cheap.