Mr_Odwin

For columns A and B. Set 1 as the first entry of the second column then this badboy: =IF(A2=A1,B1+1,1) as the second and draaaaaaag.

You really should read the rest of the thread!

I sometimes use Friendcaster - it is a pretty good client.

Weirdly I could see all the posted solutions in that thread from my phone when I looked at it. Now it's all hidden. If you look at the source you can still see what people have suggested.

On my phone still. You need to reshape the data from wide to long format. using those key words might help you in google. Btw, I don't know if you can do this in excel, but I do it in my statistics packages loads. Had a look myself: http://mobile.experts-exchange.com/Q_26549515.html That may help.

The vlookup syntax is VLookup( value, table_array, index_number, not_exact_match ), so that's why you use false for exact matches.

Use the if function to with the len function to determine how to treat it. Sorry, on my phone now so can't be much help.

Because I'm awesome.

Use VLOOKUP(N5,$U$16:$V$23,2) then drag.

The magic of a training cone. The new keeper I'm bidding on has one too.

Have you finished your manual task yet? =IFERROR(LEFT(L4,FIND("/",L4,1)-1),L4) LOL.

With the right one, it counts characters from the right so you'd have to use the Len function to find the length of the string. It would be something like =RIGHT(L4,LEN(L4)-FIND("/",L4,1)-1) or close to it anyways - you might have to adjust the -1 to +1 or not have it at all but I can't be bothered to work it out in my head! Edit: You fixed it yourself. I hate you. Also stick a false in there as the last argument so that it only gives exact matches.

I'm not 100% sure what you want but for 1 I would use "vlookup" and for 2 I would use "Data>text to columns" splitting on the slash character. Maybe I've oversimplified what you need?

When EEVILMURRAY calls you out being a dick you know you've crossed a line. Kurtle, the way you communicate is sometimes too harsh.

The updated Facebook for android app is rubbish. Don't upgrade!

Need Haden to approve it then it's a done deal.

... awkward ...

But ... when is your sponsor day? I need econ to seal the deal on a player I'm bidding on. I is desperate to get him.

Anyone that can muster up 2.5 million for him I'll buy v.i.p. for.

I am looking to quickly offload my first choice keeper, Horace Biggins. He is a 24 year old 8 rated keeper with an estimated value of 2 730 600 econ. Currently form of 10 but is on training, so that would come with him. He didn't go up in the change report despite a dev value of 15, so he must be a good 8. Special qualities: Traning cone/works hard in training. I am willing to accept offers lower than his estimated value. VIPs make me an offer!

Sorted that bad boy right out.

But ... that's pretty much what I did as soon as I saw the hamster last night. I'll sort it all out tonight - tempers will have eased and the talk will flow easier. We've had hamsters before and they're such a bind (and ours lived about 3 years). We go away for weekends, or on holiday quite a lot and it's an added layer of complexity that I've not wanted.

It was my daughter's birthday yesterday. Just after I got home I went in the kids' room as Caleb was shouting for help to get down from the top bunk. There was a hamster in its cage on top of some shelves. Esther has bought a hamster. I am more angry than I have ever been with Esther. We've joked about it, but I have always maintained that I didn't want one, and now there is one. It is a huge commitment - cleaning, feeding, looking after it for years. There is time and money involved. If Esther has all this spare time why is our house not clean and tidy? Esther has entered into this without a real discussion with me, and then asked the kids to keep it hidden from me. I feel really betrayed (and I know that sounds overly dramatic). How would Esther react if I just got rid of some of her stuff I don't like? I've joked about it, and so has she, so is that enough to justify it? Obviously, no. The above all sounds trivial, but it is symbolic of an ignoring of my views. Anyways, I get the feeling that I'm being uncool about this and acting like a douche, but it has really got under my skin.

*Nonchalantly sits in office with air con.*

Young good players are worth more than the rest of your crappyish older players? Is that really a shock?