I've reached a point in life where I'm genuinely excited about a new function I've found working with spreadsheets in Excel.
What lows have you reached recently?

Alt: metal or wood and why?
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:15, 47 replies, latest was 13 years ago)

OH JUST FUCKING SHUT UP WILL YOU?

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

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

i love a pivot table, me.
currently trying to figure out a lookup formula from said pivot table. it's all go, here.

alt: METAL \m/
( janet aylia y'all motherfuckers need jesus, Thu 2 Aug 2012, 11:16, Reply)

BLEUGGGHHH pivot table suck

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

I read that in the style of 'Hulk'

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

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

What function?

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

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)

I dun a cheer the other week
finally figured out how nested IFs work.

alt: wood, I can't get metal.
(localboy purveyor of pisspoor puns, Thu 2 Aug 2012, 11:20, Reply)

Of course they work!

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

They do once you get that
the next IF goes where you'd normally put ELSE.
(localboy purveyor of pisspoor puns, Thu 2 Aug 2012, 11:26, Reply)

Well its set up like this
IF(1,2,3)
where:
1 logical test
2, value if true
3, value if false.

2 or 3 can be replaced with any other functions of sets of functions in excel.
(PsychoChomp, Thu 2 Aug 2012, 11:28, Reply)

I'm making curtains

( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:21, Reply)

Pull yourself toget........zzzzz

( sporters I’m sincerely gratitude to you, Thu 2 Aug 2012, 11:22, Reply)

i'm disappointed no one said
beef
( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:24, Reply)

Surely we would want them opened?

( sporters I’m sincerely gratitude to you, Thu 2 Aug 2012, 11:29, Reply)

*boiks*

( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:35, Reply)

whats the functionality?
youve figured out how to 'colour the boxes?'
(Dan dan dan They tik urh jerbs!!!, Thu 2 Aug 2012, 11:22, Reply)

=SUM

( sporters I’m sincerely gratitude to you, Thu 2 Aug 2012, 11:23, Reply)

I was just excited by the discovery that I WASN'T in an email distribution group
*goes to KFC*
( sporters I’m sincerely gratitude to you, Thu 2 Aug 2012, 11:24, Reply)

Alt, both, to smash your skull in you annoying turd.

( SteveFrench Cardio is for homo's. do you even lift bro?, Thu 2 Aug 2012, 11:24, Reply)

ooh, why do we hate this one?

( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:25, Reply)

I think he's sucking up to Monty, who takes exception to me, because ...
Well - it's B3ta, innit - there's no reason not to.
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:27, Reply)

in which case i consider us best friends forever

( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:29, Reply)

Hooray!

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

Don't blame me for your arse-clenching shitness, sunshine.

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

Take it like a man.

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

He reminds me of me when I was shit(ter)
Stupid questions, needy. Wotcha cavs
( SteveFrench Cardio is for homo's. do you even lift bro?, Thu 2 Aug 2012, 11:28, Reply)

Oh there IS an attempt at justification.
Christ.
( Je suis un vagabond is an unfunny, up your own arse middle class knob, Thu 2 Aug 2012, 11:29, Reply)

morning
how's life, bobs?
( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:29, Reply)

Grand thanks, how's the curtains coming along? Have started a new thread so I don't vomit blood

( SteveFrench Cardio is for homo's. do you even lift bro?, Thu 2 Aug 2012, 11:30, Reply)

OK
gonna take a while, i'm handsewing the ribbon on
( Citizen Cavy Admires your passion for conformity, Thu 2 Aug 2012, 11:32, Reply)

wood, 'metal' is for autistic quenders.
And I'm a whisky lover.

Hey Monts- Weatherall has a live streamed gig from Eastern Electric coming up.
(dozers, do fuck off ur a nob m8, Thu 2 Aug 2012, 11:33, Reply)

I hope it's a rockabilly set. His collection is awe-inspiring.
Last heard by me when he warmed up for Jim Jones last year.
( Monty Boyce, My cheese game is strong, Thu 2 Aug 2012, 11:35, Reply)

it's house I think
Did you hear the sci fi lo fi mix he did? Also, the mist recent Two Lone Swordsmen stuff will be up your street.
(dozers, do fuck off ur a nob m8, Thu 2 Aug 2012, 11:46, Reply)