Welcome to Live View – Take the tour to learn more
Start Tour
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.
Show More
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'
Sammy Shunter.
I would be using 'Sarah's Law' before taking any kids to this event.
FFS, wrong thread. Meant for Sparkmaster train thread. Although the same applies to typing anything into my laptop recommended by Ken imvhaho
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Who said that the forum is rubbish these days ?
We want more threads like this one.
We want more threads like this one.
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.
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.
Martin's a dalek and he's fallen down the stairs.
I don't seem to be able to post on this thread now either? Same thing happened earlier on.
So what rattled his cage then, is there a formula for that?
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539