almost there
Title: Final negotiations
A need put forward with agression
required a geometric progression
without sumproduct
I would have been
but the solution relieved the tension
Hope this was useful or entertaining.
Ode to a Dead Accountant
There was a bookkeeper who used Excel
And knew it exceptionally well
But to his dismay when he died
He went down where he fried
And they only have calculators in Hell.
The next challenge:
a function piece of code that scans as a limerick.
And I think we should allow it to be a group of 5 lines in a larger piece of code.
Hope this was useful or entertaining.
Ode to a Senseless Function
If NewVal = OldVal And OldVal = 8 _
Then OldVal = SomeVal / Date
On Error GoTo Next
Activesheet.Unprotect
Worksheets(1).Rows(15).Calculate
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Well done. Made me smile.
Hope this was useful or entertaining.
Ode to an Ungrateful Twit
A bonehead once visited this site
And wrote on here nothing polite
Demanded his needs we meet
But our revenge was so sweet
Sans our help his mess was ne'er set right.
Ode to Text Functions
First, learn Search, Substitute, and Replace
Then Upper and Lower for the case
Left, Right, and Mid come next
Then you can handle most text
Or just type what you want in the first place.
Very nice...
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
a singer called James blunt
censored
he sang out of tune
rhymed moon with spoon
censored
Last edited by martindwilson; 04-01-2010 at 06:32 PM.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ummm....the connection to excel here is what?
none at all! just wanted a rhyme for blunt lol
but
I don't see any excel connection in thread titleThe Excel Limerick Collection (all styles) !
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
ok try this
in response to a simple question
Adam lloyd did sumproduct mention
but the man from Mumbai
from a help desk think I !
said "Sir,I tried this and it works fine for any column (N) that is not the
result of a formula. The data in column N is the result of a long
formula, and when I try and use this sum product equation to total the
values in column N I get the VALUE error, that's not my intention"
Last edited by martindwilson; 04-01-2010 at 09:37 PM.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Good one !
Hope this was useful or entertaining.
An OP used an array with conviction
a response said another direction
an hour or so had to pass
before he created a class
his code for the forum a valediction
Hope this was useful or entertaining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks