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 669 posted 10 years ago by kidmizere
Assuming that cell E15 contains a Belgina code consisting of four numbers
0 601 posted 11 years ago by shahways
0 645 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 730 posted 12 years ago by palimadra
http://p2p.wrox.com/excel-vba/65142-sum-group-values-based-cell-criteria.html
0 608 posted 12 years ago by hairajeshk
0 353 posted 13 years ago by darfix
Es muss eine Formatierung gespeichert werden (Format :: Formatvorlagen) Einzutragen in: Format :: Bedingte Formatierung
0 482 posted 14 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 1175 posted 14 years ago by softmechanics
This script will also work on any spreadsheet program like Google Docs.
0 574 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 737 posted 15 years ago by jimfred
« Prev 1 Next »