Welcome To Snipplr
Everyone's Recent Other Snippets Tagged excel
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« 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
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
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 »