Search results

saw you on the a41 near hooton heading the opposite direcetion, first time ive seen a v6 around here. about mid day yesterday

are the they guys over in leeds? what sort of cost do they do?

been looking forward to this for a looong time, cant wait!

righto, i think it is time to start thinking about a remap/rolling road session for my automobile! Is it best to go to someone who knows renault, or will any decent rolling roadist do the tricks? Can anyone recomend anyone to do this sort of thing in the north west? Cheers!

never seen =GET() before, I think if you name the range and then dont add to the bottom - insert a row in the middle, it should stay good?

i kinda had a feeling a countif would be all you needed but i wasnt sure how you were linking qualifying records to dealers, are you sorted?

I'm not exactly sure what is happening now, a screenshot maybe? I'm not exactly sure of the dealer and how you are going to get it to the other records we solved earlier.

how are you linking specific different dealers to a record that just says 'qualify', by the code? (66666 etc)

upload it if you get stuck, use something like sendspace.com !

odd, "66666" wouldnt work for me, I had to get rid of the apostrophes... i guess you must have the cell category set to something different than me. but meh, it works :p

it means 'not equal to' basically, sometimes in programming != is used, but excel seems to only accept <> So basically it is saying C1 is plan A and D1 is not motability and B1 is any of your codes, the answer is TRUE (change to your cells where appropriate obviously!) then the If statment is...

oo I have made a mistake then, change D1="motability" to D1<>"Motability" unless I am not understanding the problem correctly

or this worked for me? (moved your data around in a test) =IF(AND(OR(B1=66666, B1=77777, B1=88888, B1=99999), C1="plan A", D1="Motability"), "Qualify", "Not Qualify")

from what i am imagining, would a pivot table be suitable?

lol, never say anything is not possible ;) in english it means: if c5 is empty, output "please enter..." else, if C5 = 3 characters long (i.e. it's a code not a full name) then do a vlookup on the code else, if it's not 3, (it must be a full name) so do a vlookup on the next column (notice...

hehe thats well cool, its actually called a toughbook, i thought you just called it that considering all the batterings you have given it!!

pics!!

here is an example:

are the codes always 3 letters? I'm thinking of something like: if c5 string length > 3 then vlookup on the full name, if not then vlookup on the 3 letter code?

I have a feeling you might be using the wrong function for what you are trying to achieve; are you editing the data in T92:U323? vlookup just looks through T92:U323 for what you type in C5 and brings back the cell to the right of it, in your case. I'm sure you know that but I am just saying the...

this works for me: it's pretty similar in pre-office 2007 iirc

conditional formating, if you can find that in the menu, it should be self explanatory.

take it out and plug it in as a slave to another computer, or if you don't mind spending some money, you could try something like the following link, which will bring your HDD up as a removable drive on another PC http://www.maplin.co.uk/Module.aspx?ModuleNo=48965 you might be able to copy a...

mine came on and there was no obvious problems so I just carried on driving (maybe not the best course of action, i didnt even have smoke) then it failed the MOT on emissions, so the nice tester man put some cleaning mixture through the fuel system which he tells me cleaned the injectors and...

if you have another PC you will be able to salvage your music too.

:lolup:

has anyone got any experience with this program? I need a little help!! when i try to create a custom rule it says 'you must enter something in the name box' which I have done, there isn't anything obvious which I could have missed so I'm a bit stuck!

you defo got the encryption key password thing right? this happened to me and the problem was the password was 'ALL CAPS' so i just put it in like 'all caps' assuming it didn't matter, did the same thing you described.

i dont think my clutch is heavy at all. I can't really remember my old corsa but my dad has a kit car with a pinto in and that has a properly heavy clutch so i guess its relative

I'd say you'd be lucky for a company to even offer you a policy. Mine didn't get under 1k til I was 21.