JZ, I suggested something in Natter.
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!
Does anyone have a rec for underwater cameras?
I seem to recall some rather inexpensive contraptions that let your current camera become an underwater camera. I think it was REI, not positive. Or how good they work. They are like double bubbles, so if the first layer starts to leak, you still have the 2nd layer to keep it protected. Not sure how deep they went. Just an idea if you want to go that route, you can research it.
I read this as "underwear cameras." I think I need more coffee.
I read this as "underwear cameras."
Now there's a Flickr photostream I never want to see.
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?
Can you do a sort (forcing all the spaces to either the beginning or end)?
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.
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.
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.