Say you’ve got a table like this:
A
B
1
Date
Transaction
2
1-Jan
$ 1.20
3
1-Jan
$ 44.00
4
1-Jan
$ 2.50
5
2-Jan
$ 142.00
6
2-Jan
$ 23.00
7
2-Jan
$12,335.00
8
3-Jan
$ 5.00
9
3-Jan
$ 2,354.00
10
4-Jan
$ 65.00
11
6-Jan
$ 7.00
and you want a daily summary of the transactions, where the number of rows per day is not fixed. Tricky.
Using this forumula in cell C2:
=IF(A2=A3,””,SUMIF(A:A,A2,B:B))
and copying it down the page [...]
Not the food markets, I’m talking about the stock market. My “IRL” portfolio is within half a point of it’s break-even point, from 20% down a few weeks ago. I’ve also gone into the black on the Share Market Game, although still a long way behind Blacky. Looking at Blacky’s stocks QGC might be a [...]
I recently “mooched” Tom Clancy’s Rainbow Six from Bookmooch, and last night, I finished it. It was pretty good, but long - 850 some pages, and the boring stuff sometimes got in the way. You know how you’re reading one subplot and it’s completely fascinating, and then the author moves to another, more boring, subplot [...]
“Dr. Horrible’s Sing-Along Blog” will be streamed, FREE on Drhorrible.com, in mid-July. Specifically:
ACT I went up Tuesday July 15th.
ACT II went up Thursday July 17th.
ACT III (presumably here) will go up Saturday July 19th. (around 5pm QLD time)
All acts will stay up until midnight Sunday July 20th (approximately 5pm Monday, 21 July QLD time). Then they will [...]
Three things.
1. Skyrates
Last night and early this morning, I finished a long-time Skyrates goal: I traded my cargo-kitted and performance-kitted Nomad for a cargo-kitted and performance-kitted Lancaster. That means this to that. Most of Skyrates is trade-based, so the most important statistic is CKPH - Cargo Kilograms per hour, a function of your maximum speed [...]
Dudes on and all, hello.
Yesterday I performed the most valiant and difficult tasks of all: a day spending no money. It was kinda fun actually I suppose, considering it just meant kicking around the apartment reading my book (Tom Clancy: Rainbox Six) and playing the interweb. I went for a walk at one stage, which [...]
If anyone’s interested in helping me out, or learning a little about the wonderful world of software development, perhaps you’d consider installing the super-alpha version of a new program we’re working on?
You need to use windows of some kind, and USB drives.
Thanks!
My property allures the gentlemen to the pen,
which, upon comparison, they find yours lacking.
Whilst I agree your pen could be improved,
Alas, that is not a free service.
I’m pretty busy today, but I wanted to quickly wish Godfrey a happy birthday with an inappropriate, kinda gross comic:
We are pleased to advise that the Westpac 2008 interim dividend payment was paid on 2 July 2008 and your Shareholder Newsletter is now available online.
The Westpac 2008 interim dividend paid was $0.70 per share, fully franked.
Woo! The answer to “Who loves banks?” is me. I’m no Blacky, but perhaps my Wall Street genius levels [...]