Recent content by yourcodenameisnick

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.