Welcome To Snipplr


Everyone's Recent Other Snippets Tagged excel



« Prev 1 Next »
This formula will automatically change a cell's background color if there is data in it. You can also change the formula to only fill cells where there is no data.
0 665 posted 10 years ago by kidmizere
Assuming that cell E15 contains a Belgina code consisting of four numbers
0 597 posted 11 years ago by shahways
0 640 posted 12 years ago by silentpro
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 enter...
0 725 posted 12 years ago by palimadra
http://p2p.wrox.com/excel-vba/65142-sum-group-values-based-cell-criteria.html
0 603 posted 12 years ago by hairajeshk
0 351 posted 13 years ago by darfix
Es muss eine Formatierung gespeichert werden (Format :: Formatvorlagen) Einzutragen in: Format :: Bedingte Formatierung
0 481 posted 13 years ago by tscheckenbach
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 -...
0 1160 posted 14 years ago by softmechanics
This script will also work on any spreadsheet program like Google Docs.
0 571 posted 15 years ago by pollusb
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.
0 728 posted 15 years ago by jimfred
« Prev 1 Next »