Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
I think your only problem here is that you haven't tracked it, you've made a car that is utter crap from day to day on the road, in order to make it great on the track, but you only drive it on the road?
The bold bits, are your problem.
After a quick google, it threw up this, I have no idea if it works...
=SUM(COUNTIF(A1:A100,"Cat"),COUNTIF(A1:A100,"*Cat"))
or for more than one column aparently?
=sumproduct(--(countif(offset(a1:ch1,row(a1:a7)-row(a1),),"cat")>0))
FFS Do I have to do it all....
Exactly what you want :D
The only thing that was getting me, was that it looked like that lock ring wouldn't come out without removing that nut, but if you say it does, then fair play :)
Cheers.
Because not everyone treats it like its a Faberge egg?
At the end of the day its a phone, some people just use and abuse them and see them as a "tool", others, like myself, treat it with care as its a nice bit of tech, I'd screw if I scratched my tv or laptop too!
That nut? Seriously? What a terd design :(
Cheers for the advise, a drift, never heard that before, lol!
One last thing, what stops the bottom of the mount from spinning when I try to undo the top?
Drift?? Why don't touch the nut Danny? Getting so much conflicting advice!!!
lol!
Ben - Thanks a lot for the pic, brilliant.
Gally - I've got to buy some, £38 a side for the "kit" from my motor factors :(
If you do, I'll come over and confiscate the FRP myself.
The size of the "knock" I now have coming from them is un-true.
Brake, turn, accelerate hard, go over a bump, KNOCK.
Now I can't say how hard the car was driven before me, but I really haven't given it hell, so I don't expect it tbh...
I know they play a big role mate, but what order to things have to come off in?
I'm going to just f**k 'em right up in the end, get the grineder out or something. lol
I tried to move it with some stilsons, but it feels really stuck, could it be more difficult with the car on the ground? i.e the pressure on them? So easier with the car in the air?
I think I'm going to try removing it without removing the big top nut first, then if that fails, off comes the...
Dave, does that central nut not have to come off first? the big bugger? Because I couldn't even move the outer "ring" with a c spanner whilst it was on there.
I've got coilies too.
I've fitted lowering springs to my non sport before myself, so I know the standard setup, but its just the setup...
I did ask before but got no real answer...
I never fitted these so I'm pretty clueless.
Do you have to undo the top large nut, then undo the "body" with a cspanner?
Also, what can I expect to find underneath? Anyone got a pic not fitted?
Pic:
I changed mine just a week or so ago, the phone you get from apple comes with a 90 day waranty, but if you can get the phone working using a friends mac or whatever it does scream to me that there is something not right with the machine you're plugging it into.
This won't stop Apple giving you...
Jeebus, just looked at the useage on my '4 and its over 200mb already :(
I have been connected to the net a bit but god knows how much of it is.
I know its still unlimited, but its a bit s**t for when its not.
O2 need to add data useage into their app, not just texts/minutes.
EDIT: Where on...
Cheers Leigh. One of my guys on site has a bottle in the garage, free bottle, plus favour from air con engineer, equals sweet
Gray, I don't understand your first comment? lol!