You've pitched this thread too high.

( tangledupinblue hairy badge with moving eyes, Thu 9 Aug 2012, 12:38, 1 reply, 12 years ago)

I know, I should have talked about the dominoes I ate and enjoyed.

(PsychoChomp, Thu 9 Aug 2012, 12:40, Reply)

OH nice one.
Now the next poor cunt that plays will find half the pieces missing.

Selfish prick.
( Kroney, Thu 9 Aug 2012, 12:41, Reply)

What kind?
I'm doing fish fingers and potato animal shapes tonight. It's teh kind of poverty dinner I can imagine Monty having to eat, but I do it out of choice and therefore it's fun and "ironic"
(Bazongaloid, Thu 9 Aug 2012, 12:41, Reply)

I had onions olives mushrooms and spicy beef.
Baroness had pepperoni, peppers and jalepenoes. Both medium

We swapped a quarter with each other.
(PsychoChomp, Thu 9 Aug 2012, 12:42, Reply)

Now this thread is starting to come alive.
Also, I don't understand your sex slang.
( tangledupinblue hairy badge with moving eyes, Thu 9 Aug 2012, 12:44, Reply)

that's effectively a marriage proposal
you could have Dominos at the reception
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 12:45, Reply)

i never get invited to anything :(

( Light In Chains maker of the ikea sofa, Thu 9 Aug 2012, 12:46, Reply)

That's cos no one likes you.
Don't worry, they never invite me either, although I like to think that it's purely a distance thing in my case.
(Poppet some assembly required., Thu 9 Aug 2012, 13:01, Reply)

That's pretty generous.
I left the mrs have a slice of mine, and then I finish off hers because she never eats a whole pizza.
(Bazongaloid, Thu 9 Aug 2012, 12:47, Reply)

If I stop to take a breath mine would be taken from my plate.

(PsychoChomp, Thu 9 Aug 2012, 12:49, Reply)

Is she massively fat? You know, orca fat?

( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 12:50, Reply)

Very skinny. but greedy.

(PsychoChomp, Thu 9 Aug 2012, 12:50, Reply)

Bad luck that was a trick question, you were supposed to answer "she will always be beautiful to me no matter what she weighs"
You're dumped, turn to page 558
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 12:54, Reply)

Nah I think I'm ok.
Bonus context news link www.bbc.co.uk/news/science-environment-19180983
(PsychoChomp, Thu 9 Aug 2012, 12:57, Reply)

Batterd's wife must be a land whale

( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:01, Reply)

Excel Question:
I have a filtered column with numbers in, I want to add up the list, but it adds the entire column including those hidden rows. How do I stop it being spastic.

Yours excitedely NA
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:04, Reply)

What column have you filtered and what's it filtered by
what column are you summing up?
(PsychoChomp, Thu 9 Aug 2012, 13:14, Reply)

It's a looooong column of figures
It has a drop down filter which i've used to only show figures from Company X. I want to add these
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:17, Reply)

Well seeing as you didn't answer my questions.
If the company name is in column A and the numbers you want to add up are in column b, this would work
=SUMIF(A:A,"Company X",B:B)

Filters are for losers.
(PsychoChomp, Thu 9 Aug 2012, 13:21, Reply)

You're like an Excel Yoda.

(Bazongaloid, Thu 9 Aug 2012, 13:24, Reply)

Oh soz, no all in one column
Filters are imperitive I have more than 4,000 rows
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:24, Reply)

How do you mean all in one column?
like this
company A
fig A
Company B
Fig B

etc?
(PsychoChomp, Thu 9 Aug 2012, 13:26, Reply)

Or so that they're in the same cell
so
company A, £3000
company B, £2300
(PsychoChomp, Thu 9 Aug 2012, 13:28, Reply)

done it by hand now....
it's a list of numbers in column N, I have added a filter to another column so only compnay A's results show in column N, but running a sum across all tyeh visible cells in column N adds up the now hidden cells as weel, whcih is bent.
( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:31, Reply)

Well you could have just changed the formular I gave you
to =SUMIF(#FILTERED COLUMN#,"#FILTERED BY#",N:N)
(PsychoChomp, Thu 9 Aug 2012, 13:33, Reply)

Is that one row for each individual customer of the particular supermarket branch whose data you are analysing?

( tangledupinblue hairy badge with moving eyes, Thu 9 Aug 2012, 13:26, Reply)

what excel formulas do use to make girls like me?

( glued eel /questions/questionsyoudliketoask/post1648081, Thu 9 Aug 2012, 13:25, Reply)

=VLOOKUP(skirts)

(PsychoChomp, Thu 9 Aug 2012, 13:26, Reply)

excelols

( Naked Ape call me Caitlyn, Thu 9 Aug 2012, 13:29, Reply)

=IF("age"<18, SIN(), STDEV())?

( glued eel /questions/questionsyoudliketoask/post1648081, Thu 9 Aug 2012, 13:42, Reply)

SORT (yourself, out)
or:
ROUNDUP, COUNTIF RANK, IF NOT LARGE, GETPIVOTDATA, IMCONJUGATE.
(localboy purveyor of pisspoor puns, Thu 9 Aug 2012, 13:30, Reply)

SUBTOTAL function?

(localboy purveyor of pisspoor puns, Thu 9 Aug 2012, 13:18, Reply)

OH COME OVER HERE AND POST MY LINKS EH?

( glued eel /questions/questionsyoudliketoask/post1648081, Thu 9 Aug 2012, 13:20, Reply)

/film

( sporters I’m sincerely gratitude to you, Thu 9 Aug 2012, 13:01, Reply)

double six is well tasty

(localboy purveyor of pisspoor puns, Thu 9 Aug 2012, 12:43, Reply)