Log in

No account? Create an account
He's just this guy, you know.

> Recent Entries
> Archive
> Friends
> Profile

Schlock Mercenary
Something Positive
Irregular Webcomic
Sluggy Freelance

November 22nd, 2005

Previous Entry Share Flag Next Entry
02:03 pm - Geeky Excel thought ...
The other day, I realised that Excel's so-called "PivotTables" are just dressed-up SQL Select / Group By expressions.
I wish they'd just explain them that way in the first place, rather than leaving them as vaguely defined possibly-useful things.

(Also wish they'd picked a different name, because "pivot" is a term for a standard matrix operation, and I kept running across the Excel kind when I was searching for the matrix kind).
Current Mood: geekygeeky

(2 touches | En garde !)


[User Picture]
Date:November 23rd, 2005 12:55 pm (UTC)
Pissed me off no end when I was first trying to make Excel work.

> Go to Top