What function?

(PsychoChomp, Thu 2 Aug 2012, 11:19, 2 replies, latest was 13 years ago)

I once in a email, instead of the word "yesterday" wrote =TODAY()-1

(PsychoChomp, Thu 2 Aug 2012, 11:21, Reply)

No-one is surprised by this.

( Monty Boyce, My cheese game is strong, Thu 2 Aug 2012, 11:22, Reply)

Pivot tables.
I was entering data manually - now I can automate it! HUZZAH!

I was meant to be playing bass with New Model Army by this point in my life.
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:24, Reply)

Pivots are good if the final result you want is a pivot table
if there's any other steps then they're shit. Much better to use =countifs and =sumifs
(PsychoChomp, Thu 2 Aug 2012, 11:26, Reply)

I'm making graphs.
Specifically, peak flow graphs.

It seems to be alright for that, but I need to get my head around them. Is there a way to make it include zeros where there isn't any data?
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:28, Reply)

If(E5='',"0",E5)
will replace any blanks with a zero, if you're looking at cell E5 obviously.
just copy that down in a new column
(PsychoChomp, Thu 2 Aug 2012, 11:29, Reply)

Aren't you missing a " in that equation?

( Ken Oath, Thu 2 Aug 2012, 11:32, Reply)

single pip for the first bit double for the second... not sure why but it works.

(PsychoChomp, Thu 2 Aug 2012, 11:34, Reply)

Oh, there you go...jolly good!
...never knew that. Also works with double "pips" too.

I like Excel....useful for working out 7 parameter transformations to convert raw GPS data to Transverse Mercator Map Grid co-ordinates.

Also like wood, not metal.
( Ken Oath, Thu 2 Aug 2012, 11:38, Reply)

So, a racist ruiner AND a dullard, eh?
Good Lord Oathsy, you just get better and better.
( Monty Boyce, My cheese game is strong, Thu 2 Aug 2012, 11:42, Reply)

May open-minded bisexual supermodels play in your dreams.

( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:33, Reply)

You'd fit right in with New Model Army.
They're a bunch of shit, tedious wankers.
( Monty Boyce, My cheese game is strong, Thu 2 Aug 2012, 11:28, Reply)

Pivots ae ace... but can be really frustrating and confusing
depending on the data your using...

I like Vlookups.
(Dan dan dan They tik urh jerbs!!!, Thu 2 Aug 2012, 11:44, Reply)