The Ministry

Things said by smart people

Gallery o' photos

Kinfolk

The late, lamented Left-Wing Frisbee game

Excel things

Sir Kraab sez: Excel is the only thing Microsoft ever did right.

Conditional formatting

• Formatting every other line: =MOD(ROW(),2)=1
• Formatting odd values: =MOD(A1,2)=1
• Formatting even values: =MOD(A1,2)=0

Paste It Special-Style

Copy, Paste Special . . .

• Transpose
• Values

Subtotal functions

• 1 Average
• 2 Count
• 3 Count A (not empty)
• 4 Max
• 5 Min
• 6 Product
• 9 Sum