Chit Chat
There is currently 1 person viewing this thread.
02 Aug 10
15:30
Joined:
Date Joined:
08 Dec 05
Ken, you're a gentleman and a scholar. Thank you very much indeed for your formula posted on my earlier thread.
My sincere apologies that it has taken me so long to acknowledge your kind advice, but none of it appeared whilst I was chatting to Mr Grumpy. I only noticed it much later when I had logged out and then back in again - and then for some reason the Betfair site crashed on me! And I still cannot post on the original thread, only read it.
Anyway, Ken, I have tinkered with your formula to fit my needs and it works perfectly. Thank you again to you and Mr Grumpy.
My sincere apologies that it has taken me so long to acknowledge your kind advice, but none of it appeared whilst I was chatting to Mr Grumpy. I only noticed it much later when I had logged out and then back in again - and then for some reason the Betfair site crashed on me! And I still cannot post on the original thread, only read it.
Anyway, Ken, I have tinkered with your formula to fit my needs and it works perfectly. Thank you again to you and Mr Grumpy.
sort by:
Show
per page
Replies: 26
|
By:
I presume that this formula was the ratio of viagra to cocaine that is used by the Chinese to ensure that 'Mr Grumpy' is transformed from his lifeless state into a chemically roused 'Mr Happy'
|
|
By:
Oh man, now I feel bad.
|
|
By:
I wouldn't take that Ken. MVB Blatantly taking the p1ss.
|
|
By:
 Sammy Shunter. I would be using 'Sarah's Law' before taking any kids to this event. |
|
By:
FFS, wrong thread. Meant for Sparkmaster train thread. Although the same applies to typing anything into my laptop recommended by Ken imvhaho
|
|
By:
Oh noes, you're on the wrong track.
|
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
there's an echo in here.
|
|
By:
LESS THAN SIGN problems imo
|
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
I don't know what's rattled UTI's cage, I would never be so rude as to deliberately blank somebody's kind help.
Here is Ken's formula with my mnor alterations: =(RANK(Q7,Q7:Q34,0))&IF(AND(MOD((RANK(Q7,Q7:Q34,0)),100)>=10,MOD((RANK(Q7,Q7:Q34,0)),100) |
|
By:
=10,MOD((RANK(Q7,Q7:Q34,0)),100)
|
|
By:
=10,MOD((RANK(Q7,Q7:Q34,0)),100)
|
|
By:
This is going well, 150+ imo.
|
|
By:
Who said that the forum is rubbish these days ?
We want more threads like this one. |
|
By:
Ken, note how I had to include the range Q7 to Q34 and the zero to ensure the column sorted the numbers in descending order.
I have learnt all that today from nothing thanks to you and Mr Grumpy. I had never used a spreadsheet at all before this morning, so I am quite proud of myself. I am using it to keep track of my spread betting punts on the stock market, of which I am also a novice. Thanks again. |
|
By:
Martin's a dalek and he's fallen down the stairs.
|
|
By:
I don't seem to be able to post on this thread now either? Same thing happened earlier on.
|
|
By:
Are you sure you're not Tommy Toes?
|
|
By:
So what rattled his cage then, is there a formula for that?
|
|
By:
Saving for later...
|
|
By:
ffs, get a life!
|