I don't remember if I have mentioned this before, but if you want to return the Smallest Non-Zero Value, use array.
=MIN(IF(A1:A5=0,MAX(A1:A5),A1:A5))

(entered by pressing Ctrl+Shift+Enter)

You can make the formula even shorter by turning it around in this manner:
=MIN(IF(A1:A5<>0,A1:A5))

I have noticed an odd thing when it comes to creating CSV files with Excel: the files are not always consistent in how they end each row in the output data. When I create a CSV file that has, perhaps, 70 field (columns) of data and then views the CSV file in a text editor, I noticed that the records all contain carriage returns, but in different places. How do I get the CSV files to contain a consistent number of output fields.

This is actually a problem that has been known to Microsoft for quite some time. The Microsoft Knowledge Base includes an article on this topic as early as Excel 97:

http://support.microsoft.com/?kbid=77295

http://tinyurl.com/a4gyb

Excel include a feature that really annoys some people: Paste Options. When you paste some tidbit of information in your worksheet, Excel displays a small, floating "button" right near the end of the pasted information. Follow these steps to turn it off:

1. Choose Options from the Tools menu. Excel displays the Options dialog box.
2. Make sure the Edit tab is displayed.
3. Clear the Show Paste Options Buttons check box.
4. Click on OK.

A way to quickly search for free comic books online using Google if you are looking for title specific searches.
-inurl:htm -inurl:html intitle:"index of" "Last modified" spider-man cbr
to find simpsons...
-inurl:htm -inurl:html intitle:"index of" "Last modified" simpsons cbr

how to search for a line break (Alt+Enter) in a cell?
Press Ctrl+F to display the Find tab of the Find and Replace dialog box. In the Find What box, hold down the Alt key as you type 0010 on the numeric keypad.

http://tinyurl.com/2copgb

You can create a multi-line header or footer in Excel. The trick is to remember that you cannot press Enter while typing your footer. Instead, to start a new line you should hold down the Alt key as you type 0010 on the numeric keypad. This inserts a line-break character in the footer text. The total length of a header or footer cannot exceed 255 characters.

you can jump to the last place that you edited in a document by pressing the Shift+F5 key. In other words, open the document, press the shortcut, and the insertion point jumps directly to the last edit point in the document.

Use the wildcard character (*) for companies that use multiple types of address from the same domain. One great use I’ve seen is to use the wildcard character for vendors such as Amazon or eBay to make it easier to track online purchases. Create a label (online shopping) and a filter with such email addresses as *@amazon.com|* @ebay.com|*@paypal.com|* @barnesandnoble.com

While you enter a formula in a cell, press CTRL+SHIFT+A to see the arguments in a formula. If you type =RATE, and then press CTRL+SHIFT+A, you can see all the arguments for that function--for example, =RATE(nper,pmt,pv,fv,type,guess).

The image results for Paris are pretty diverse, but most of them are about the French city and Paris Hilton. Now let's restrict the images to faces by adding &imgtype=face (or =news) at the end of the URL: we get all kinds of images, but all of them show faces. Google uses face detection technology to select only images that contain faces and that may be the first visible result of the Neven Vision acquisition.