Match date in List 1 with List 2, if there is a match take second column from each table and put them in new table. See VLOOKUP and Filter Method and VLOOKUP-SUMPRODUCT-INDEX-MATCH Method.
Archive for the ‘iPhone 4g’ Category
Real Time Drawing Tutorial 1: Sailor Moon
25 October 29th, 2010OK, so here’s the first part of the tutorial. It presents basic head structure and how to plan it out and draw it. This is just my method of drawing sailor moon. you’re totally free to use it if you’d like. If you DO plan to use my method, i assure you the first few times you try it’s not gunna look cannon, but if you try a few more times, you’ll eventually get it, then you’ll never have to use references when drawing sailor moon again! =D So the camera is hanging from the ceiling, if you think there’s a better way to record videos in the future, please don’t hesitate to suggest. Feel free to leave comments, critiques, suggestions, requests, etc. Thanks for watching =) Coming up: -Sailor moon 1/4 view -Mercury and Mars faces -Venus and Jupiter faces -Pluto and Saturn faces -Neptune and Uranus faces -Chibi Moon and Tuxedo Mask faces -Suit changes from normal to super henshin -Prism, Crystal, Cosmic suits -Crisis Suit -Eternal suit(maybe…i hate this suit) -Princess Serenity dress *Subscribe so that you’ll get the latest videos when they;re uploaded =P
iPod Event Recap:New iPod Touch 4th Gen, iPod Nano Touch Screen, iPod Shuffle, Apple TV
6 October 28th, 2010Apple Event News Sept 2010 Recap James Davis Jr
