Search results

Use a pivot table.

If you're not going to buy any games then save yourself £100 and get the 64GB version. I bought one 6 weeks or so ago and unless you're spunking £100's on games quickly then can't see why you'd need the bigger version.

Is the Quest any good? I'm almost put off because it smartphone tech, and also I'll probably get bored after a few hours of it.

Then it's probably a different version of Excel (2003 vs 2016 or something). Try saving the old file down as the same version of Excel then trying to copy and the formulas across. Like if the formula you want is in a .xls file try saving it as a .xlsx version or whatever the other spreadsheet...

Can't you just copy and paste the cells as they are in the original spreadsheet, straight into the 2nd spreadsheet? Or when you go to paste, right click>Paste Special>Formulas

Yes you need to use a countif formula. Something like: =countif(a:a,d1) Where A:A is the column containing your list of names who have done reports, and D1 is your unique list.

I don't get what you're after? Are these cells empty or do they have values (text or numbers) in them? Why do you want to do this? (the understanding might help with the answer)

I'm not sure if anyone is interested. I want to describe it as like a slightly cheaper, slightly slower Clio 1*2. But I think you have to just "get" it if you know what I mean? http://www.ebay.co.uk/itm/Suzuki-Ignis-Sport-2004-VVT-/132219446868?hash=item1ec8e4a654:g:wkYAAOSwK6RZOGab

Sorry to hijack this thread, but I've just found these in the house. If I bought a DVR (eg this one with a wireless adaptor http://www.ebay.co.uk/itm/252714040315?_trksid=p2055119.m1438.l2649&var=551908838387&ssPageName=STRK%3AMEBIDX%3AIT) would it work alright?

My car was stolen last year, they broke into the house in the night to find my keys to the car. Ever since then I've been really jumpy, so something like this where I can monitor the house even whilst I'm in it would be great.

Any other way of getting the footage off the NVR? The NVR box would sit in a built-in wardrobe so there's no space for a monitor.

With this NVR box thing, is it easy to connect to the router? Or what is the other way of watching the camera back? I want to put two cameras together, one looking back into the garden, and another looking onto the drive. I could feed a wire from each camera into a room in the house which...

I wonder if IDDQD still works?

The programming of the software would have cost tens of £'000s. And offering a shiny box and CD will add no value to you as most people's internet nowadays can download 73mb quicker than you can load a CD.

Take out the 2nd vlookup. The 0 is only there if there's an error.

I was offered around that amount for my 05 reg Inferno cup though with another 10k miles. I argued and tried to get the price up, but to no avail. I think they use a Glasses valuation, but I think they're quite out of date. Which insurers are you with?

Ok, so the things have progressed so for those interested I'll post all the details. It's a bit late though, and I'm knackered so apologies for anything that doesn't make sense. I'm insured through Adrian Flux, who outsource their claims to a company called ULR. Unfortunately they passed me...

Is it a wheel from a compact? Where's the best place for parts on these on the t'internet? And any decent forums around?

This thread made me but one of these! Hopefully will be insuring myself on it tomorrow then selling the Clio.

Same as I asked before: "Clio 182 Cup in Inferno - 2005 05 reg. Just under 76k miles. I'm the third owner. FSH, serviced last in May. MOT until May 2015 (no advisories!), tax until end of Oct 2014. Rear tyres only 1000 miles old, front have plenty of tread and are probably 4000 miles old. Belts...

Thank you - you're right that people don't know about payouts and such after a claim. It appears that it's just good customer service to allow the crashee to have the car a little longer. I thought "company B" had collected money (for their "services") off the third party so just wanted to get...

Well a slight update - the Clio is now back on the road. I had it MOTed and it passed no advisories.. Again! I only needed to get a clamp fitted to the exhaust. I still have the hire car though, and they've said they'd pick it up three times now but no one has turned up. I'll let them chase it...

Very nice. I'm thinking about one of these for my next car. Apart from petrol consumption any downsides to the car?

Need a valuation from the ones that know please. Clio 182 Cup in Inferno - 2005 05 reg. Just under 76k miles. I'm the third owner. FSH, serviced last in May. MOT until May 2015 (no advisories!), tax until end of Oct 2014. Rear tyres only 1000 miles old, front have plenty of tread and are...

I like this response. But can I actually do this? I suppose not, but then I suppose they shouldn't be treating me like this.

I was concerned I want getting the money at all. These kind of companies are awful. Again the hire car still hasn't been collected as promised - the third day in a row. I really can't be bothered with them. And thanks to Dan. Nice to get good advice from an expert.

I thought that was the case, my knowledge on my rights is non-existent, which is one of the reasons I've started this thread. ----- I've just checked my bank, and the money is finally there. That's one issue off my mind!

Repair bill is understandably large, I expected them to write it off. Yes they offered a value far below a replace 182 cup in the same condition/age/mileage/colour. I understand it is normal for write-off offers to be low at first though, so I will await their response to my dispute. I suppose...

I don't want to say how much I was offered at the moment (I'm probably not helping myself), as the claim is still pending. Yes it's an inferno 182 cup. I was given an Audi A3 1.6tdi, which is fine for my needs.

Hi, I think I'm being given the round around following a non-fault accident, and I'm losing out because of it (both money and sleep!) I'll try and keep it brief: 1. Had an accident 2 weeks ago on Saturday 14/6, I got rear ended. Third party admitted fault and gave me his insurance details - no...