Extras

Excel

SumProduct

This Excel formula counts the number of unique items in a cell range and excludes blanks:

=SUMPRODUCT((A2:A10<>"")/COUNTIF(A2:A10,A2:A10&""))

It can also be used instead of complicated array formulas or pivot tables, which can be very useful for certain applications.

=SUMPRODUCT(--(A1:A10="Luke Skywalker"),--(B1:B10="West"),D1:D10)

sumproduct

Latitude and Longitude Conversion

From degrees, minutes and seconds to decimal. The formula can be used for both Lat and Long.

From: W 114° 5' 7''
To: -114.0852778
Use: =-(VALUE(MID(D5,3,FIND("°",D5)-3))+VALUE(MID(D5,FIND("°",D5)+2,FIND("'",D5)-FIND("°",D5)-2))/60+VALUE(MID(D5,FIND("'",D5)+2,FIND("''",D5)-FIND("'",D5)-2))/60/60)

CSS

Some usefull CSS. HTML Encoder used for proper display.

Dropcap the first letter of a paragraph

<div class=”dropcap”><p>Copy goes here.</p></div>

.dropcap > p:first-of-type:first-letter{
font-family: Georgia,serif;
font-size: 75px;
line-height: 65px;
float: left;
margin-bottom: -10px;
position: relative;
margin-right: 8px;
color: #333333;
}

Elliot