So I've got a spreadsheet with a massive amount of data by month.
July DOG 1
Aug DOG 2
July CAT 3
Aug CAT 4
I want to run a vlookup against the DOG/CAT column and return the value for the specific month. A regular vlookup will simply return the first one. For example if I want to find...
FIFA 12 - Sep 30
NBA 2K12 - Oct 4
Twisted Metal - Oct 4
Batman: Arkham City - Oct 19
Battlefield 3 - October 22
Uncharted 3 - Nov 3
COD: MW3 - Nov 8
Skyrim Nov 11
Assassin's Creed Revelations - Nov 15
Super Mario 3D Land - Nov
Ultimate Marvel vs. Capcom 3 - Nov
Star Wars: The Old...
In the wake of the inaccurate game against Sydney a lot of the talk has been about how inaccurate Collingwood are, and how it might cost them another flag.
I thought this was a valid criticism in 2010, but in 2011 I felt we had improved a lot and this criticism was rubbish. Especially since...
Talk about everyone's favourite wrestling federation TNA (Total Nonstop Action) here.
Spoilers not allowed in this thread. If you are replying to somoene you may use spoiler tags though but it is discouraged. Create your own thread with a spoiler warning in the title if you think it warrants...
For general discussion of WWE TV as it airs in Australia.
No spoilers are allowed unless they are hidden by spoiler tags. Even then they are discouraged as we have a spoiler thread. I will delete unnecessary spoilers, even when tagged. Only post tagged spoilers if you are replying to someone...
To avoid confusion this thread is the designated spoilers thread for general Raw/Smackdown results discussion for those who like to read them/watch them before being aired in Australia.
Read at your own risk.
You can still create your own thread about a certain spoiler if you feel it merits...
Do not post spoilers unless in designated spoiler threads.
Posters posting spoilers will be warned or given infractions as the situation merits. First time offenders will most likely be warned.
What are spoilers?
Spoilers will be treated as any information posting the results of a show...
I'm revisiting the spoiler policy as it is a little vague and I'm not sure if it's what you really want. So I'm taking this opportunity to get your opinion on what should be treated as spoilers and what should be allowed on what threads.
There seems to be some confusion on the boards about...
Recently started watching this show. It was a 11 minute show that aired on the Adult Swim "block" of Cartoon Network, despite it being a live action sketch show. Adult Swim is notable for zany adult cartoons such as Aqua Teen Hunger Force, Harvey...
I have thousands of lines similar to this:
Period 1 2 3 4 5 6
Item 1 4 4 4 4 4 4 No
Item 2 4 4 4 5 5 5 No
Item 3 3 3 3 10 10 10 Yes
Item 4 4 4 4 4 4 No
Item 5 9 9 9 9 8 8 Yes
The last column are the intended results I want from the formula.
I want an if statement that shows significant...
I always look forward to these awards as I don't really pay attention to much outside TNA/WWE and it's good to see what so-called insiders actually think of certain promotions/feuds/wrestlers.
Please note that the period was from Dec 09-Nov 10. Also MMA is eligible for many awards as well as...
I've finally finished Mass Effect and Mass Effect 2 (might download DLC for the latter as well) but I still have a lot of catching up to do in playing the games I've bought through Steam sales this year and last year. So out of these games what should I start playing? Would rather play a game...
continuation of previous thread
Please post thoughts on recent Raw/Smackdown/NXT/whatever WWE puts out on TV here. New threads can be made for new storylines/ thoughts on individual wrestler etc. this is just to minimise potential spoilers and...