Search results

Sounds like a wise friend, you should probably buy him beers,

Agree I play a fair bit and rarely see a cheater. However I do only usually solo up to plat in ranked, becomes a chore after that without a team on comms. So it may be more prevalent at higher tiers in ranked.

Looks like I spoke too soon, order has just changed to shipped. Working late on a Friday, much appreciated!

Changed my order to Sat delivery but still not shipped. That's fair enough as I ordered late October and there would have been plenty of people in the queue before me. However do I need to change the delivery back to Mon-Fri to get it at some point next week?

You can do this using the sumproduct formula already used in the sheet. so for the £500 pound bracket in May. =SUMPRODUCT(('Q1'!$B$2:$B$1049>=B$1)*('Q1'!$B$2:$B$1049<C$1)*('Q1'!$L$2:$L$1049<=500)) Basically your just putting each criteria in the brackets for each part of the equation you wish...

So you want to nest if functions. An if formula is basically =(Your Criteria, Output if true, Output if false) So you would start by looking for the Yes Values =if(A1="Yes","True","False") Then instead of saying true if it find yes, you want to add another criteria...

Well if they changed to account numbers I would use still use "" and then select text instead of blanks. The only problem would come is if you had a mixture of numbers and text strings in the list.

The Problem is as soon as you put a formula into a cell it is no longer blank. Even if you force it to show nothing by forcing a blank string "", by pasting values it is not a blank or null cell. To get round it just put a number in instead of a blank string. So 0 instead of "". Then when you...

I would use a pivot table to do this. Have the dates in the row fields and the numbers in both the column and value fields. This will give you the table you want but with some blanks between numbers. to get rid of these copy into another sheet. highlight the table and hit F5, hit the...

50% of his wage is in no way excessive. He is living at home so it can be assumed that this will also include all bills, food , cleaning, ironing, cooking, Pretty good deal I would say.

Look at the Charlie Huston series, The Joe Pitt books. Quite brutal vampire books but in a kinda film noir setting, really really good.

so the data has that prefix? build a query with the following Mid([FieldName],7,(Len([FieldName])-6)) This will give you the string that starts in position 6 in the string and lasts for the length of the field -6

That's what I have, find it excellent.

Best Thai restaurant in Glasgow in my opinion http://www.list.co.uk/place/102426-thai-lemongrass/ Great Asian Fusion Tapas http://www.list.co.uk/place/22821-the-secret-garden-at-the-gate/ You can jump on the tube up to Hillhead, just a couple of stop and there are some really nice...

Posed in this thread 2 days ago that my screen had broken. All my own fault. Got home from work 30 mins ago and my brand new kindle is waiting for me. That's some great customer service.

I love my Kindle. Initially I had the same reservations about moving away from physical books. However after having a kindle for more than a year I wouldn't want to go back. Actually I am awaiting a replacement at present for a broken screen. I keep my kindle in a cover and have had no...

There is a lage Newsgroups thread in the Internet subforum however I would be careful about blatently talking about pirating films, generally frowned upon around these parts :)

Totally forgot about that bit! Although in all fairness they are probaly just giving us a kicking as we brutally slaughtered the 4 ships they sent to say hi :)

But the only people that said they were going to invade were the humans. After being the first to shoot at the aliens. We contacted them on their home world and they come to visit. On the way down one of them crashes into a satellite and needs help. Once they land our ships communicate by...

You should really give it another go, was a fantastic series.