Snipplr

(Other) Lookup Belgian provinces in Excel based on postal code - shahways

Thu, 31 May 2012 19:01:38 GMT

Assuming that cell E15 contains a Belgina code consisting of four numbers

(Other) Excel Convert Epoch Time - silentpro

Sun, 09 Oct 2011 03:47:47 GMT

(Other) Copy data from a column in a spreadsheet to a row in another spreadsheet - palimadra

Mon, 26 Sep 2011 20:47:33 GMT

In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is entered as a parameter.

(Other) Count the amount of empty cells in a column in MS Excel spreadsheet - palimadra

Mon, 26 Sep 2011 20:45:50 GMT

(Other) If is blank - amandalaine

Sat, 16 Jul 2011 07:05:50 GMT

(Other) MS Excel: Group by SUM in Excel - hairajeshk

Thu, 05 May 2011 01:59:50 GMT

http://p2p.wrox.com/excel-vba/65142-sum-group-values-based-cell-criteria.html

(Other) oOo Conditional Formatting - darfix

Fri, 11 Feb 2011 19:42:51 GMT

(Other) Excel, jede zweite Zeile anders formatieren - tscheckenbach

Wed, 24 Mar 2010 06:32:22 GMT

Es muss eine Formatierung gespeichert werden (Format :: Formatvorlagen) Einzutragen in: Format :: Bedingte Formatierung

(Other) Export a Single Sheet of an Excel Spreadsheet as CSV from the Command Line with Open Office - softmechanics

Fri, 29 Jan 2010 20:28:06 GMT

modified from branflake2267's post at oooforum.org: http://www.oooforum.org/forum/viewtopic.phtml?t=52942 usage: Paste into the Standard.Module1 macro file. Then, create xls2csv bash script containing: #!/bin/bash file="$(readlink -f "$1")" /usr/lib/openoffice/program/soffice -invisible -headless -norestore "macro:///Standard.Module1.ConvertXls2Csv(\"$file\", \"$2\")" The first argument is the xls file name, second is the name of the sheet: `xls2csv ./spreadsheet.xls "Some Sheet"`

(Other) Worksheet Name - Scooter

Thu, 23 Apr 2009 18:14:46 GMT

In speed tests, a VBA function using ActiveSheet.Name appears to be quite faster, but this formula can accomplish the same thing in situations where a macro solution is not preferable.

(Other) Excel function to extract a filename from a fullpath - pollusb

Tue, 10 Mar 2009 19:35:10 GMT

This script will also work on any spreadsheet program like Google Docs.

(Other) Interpolation in Excel using =TREND (interpolate) - jimfred

Wed, 04 Mar 2009 14:44:07 GMT

This example demonstrates interpolation using Excel's =TREND function by converting 70 degrees F to 21 Celcius. =TREND({0,100},{32,212},70) The {..} arrays can of course be replaced with a cell range specifier.

(Other) Weighted Average - Scooter

Thu, 25 Dec 2008 01:24:49 GMT

I've been doing some sales forecasting for next year and needed to do a weighted average on historical data so that I could give stronger emphasis to more recent numbers. An ordinary average may be too high in situations where the oldest number is significantly higher than more recent numbers (due to introduction of a new product, for example).

(Other) combine columns in excel to create usernames for batch creation - jhenry

Tue, 11 Nov 2008 14:47:55 GMT