How To: Return a sorted list based on row values in MS Excel
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
This video shows you how to make a tech deck quarter pipe. You will need the following materials: wood pieces, cardboard, a small metal bar, glue, and scissors. The first thing you will need to do is cut out the base, this requires cutting out three equal parts (as seen in the video). The base pieces are then glued onto a back board for support. Small slits are then cut in each base to allow space for the metal bar. Glue the bar onto the base, making sure that only the bottom of the bar gets ...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
This video helps you to draw a boat. First draw the base with double lines. Then draw a cabin and a wheel. Next draw small circles on the base. Now paint the entire lines with black. Next draw spokes on the wheel. Shade the base of the boat with a lighter brown color and over-coat it with a dark brown. Paint the cabin with orange and brown color as shown in the video. Give a dark brown to the outer area of the circles in the base and fill the inner areas with black color. Give a white line to...
Parallelogram is a quadrilateral in which both pairs of the opposites are parallel. To find the area of a parallelogram first draw the diagram of a parallelogram. Parallelogram can be further divided into squares and rectangles. To calculate the area of both of these kinds of parallelograms multiply the length of the parallelogram with its height. In general the area of a parallelogram in obtained by multiplying the base of a parallelogram with its altitude. In square and rectangle cases, the...
This video demonstrates how to make a catapult out of popsicle sticks. For this project, you will need the following: 7” rubber bands, a box of popsicle sticks, a hot glue gun, a Dixie cup, and tape.
This wordless video shows how to draw a staircase in 3d. Start by drawing the steps in one dimension. Extend two lines at the top of the stairs the width you want the steps to be. Draw another line between them to make a square. This creates a landing. Draw two lines downward and parallel to the steps from the line at the top of the stairs. This will create a rail and a second base. Then extend lines from each jut of the one dimensional steps, stretching the lines alternately to the base and ...
This is a short, very fast paced (6x normal speed) demonstration of how to arrange a floral and green head table piece. The 54 seconds shows the designer how to complete an arrangement from beginning to end. It is difficult to see what the shape of the base is, but it is fresh flowers going into the design. The designer places long greens into the center of the base, adding some long white stemmed flowers. Red carnation heads are then placed around the base along with some additional greenery...
A video to help calculator users find the natural logarithm (log base e, or "ln") and standard logarithm (log base 10, or simply "log") of any number using a TI-83 calculator (works for any issue of the TI-83 calculator or even a TI-84 calculator). Turn on your calculator. To find the natural log of a number, press the "ln" button (the third button from the bottom left), enter the number you want to find the natural log of, press the ")" (closed parenthesis) button, then press enter. The same...
If you're designing a website but are uncomfortable slicing your interface up and reassembling it with CSS, or if you'd like to add easter-egg content to your site, then an image map might be a good option. And with Dreamweaver, the process is simple.
This video shows you how to easily find the area of a parallelogram and the area of a triangle. The first part of the video teaches you how to find the area of a paralellogram. The area of a parallelogram is BxH, where B is the base and H is the height. The height is obtained by drawing a perpendicular line from one corner to the base. The second part of the video teaches you how to find the area of a triangle. The area of a triangle is (BxH)/2, where B is the base and H is the height. That's...
In this video the instructor shows how to solve logarithmic equations. To solve a logarithmic equation, the first thing you have to do is try to get one logarithmic term if possible. To subtract two logarithmic terms use the formula Log (a) – Log (b) = Log (a/b). Now to get rid of logs, perform exponentiation of the base. Exponentiation of the base is raising a number to the power of the logarithmic term where the number is the base of the logarithmic term. Here the value turns out to be the ...
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Julie teaches the secrets of creating tiger print nails inspired by Rihanna. You will need: a base coat, top coat, nail polish of gold, black and copper colors. First apply a base coat of your choice to the nails and let it dry. Now apply a gold color nail polish on the base coat. Use a copper color nail polish and fill in the tip of your nails as shown. Now use a black color nail polish to draw the tiger stripes. Start drawing a triangle and end up with a line in crooked directions to get ti...
In this tutorial the author shows how to draw a rectangle with given base b and height h values. First she uses a ruler to draw a horizontal base line of b cm. Now she uses a protractor and marks a 90 degree angle at one end of the line, then draws a straight line of h cm which is the height of the rectangle. Now she finishes the remaining part of the rectangle by drawing similar lines of the other sides. This video clearly explains how to draw a rectangle given the values of its base and hei...
GetConnected host Mike Agerbo talks to Jamie Brigden about installing the Mac OS X operating system on a Windows-based Dell Mini 9 Netbook. The Dell Inspiron Mini 9 Laptop Netbook is a hot item these days with its portability, so why do Apple users have to be left out to dry?
This is a walkthrough of Halo Wars so you can beat it before your friends do. This is the first chapter of Halo Wars for XBOX 360. Check it out, a cheat walkthrough from Mahalo Gaming.
After finishing up your paint job, you're going to want to clean the paint of your brushes and rollers to save money on replacement. Depending on the paint you used, either oil-based or water-based, you're going to need either water or turpentine to clean off the paint. Watch this video home improvement tutorial and learn how to clean paint off of paint brushes and rollers.
In this clip, we're going to be talking about how to massage away a headache. There are certain different types of headache. So after you've asked your body where the headache is specifically, if it's on the left side or on the right side, if its starting from the base of the neck, maybe even the shoulders, then that way it will gear you to where you need to be a little bit more specifically. Try massage for headache relief. Learn to treat headaches with massage in this health how-to video.
Humus is healthy and vegetarian and is mostly eaten as an appetizer. This cooking how to video tutorial shows you how to prepare a simple base recipe for hummus. Serve it as a snack, for dinner, with pita bread or other breads.
Backstreet Boys Black and Blue album cover is the inspiration for this smoky eyed look. The cosmetic products used to create this makeup effect are a blue eyeshadow base, a blue eyeliner, a blue eye pigment, a blue eyeshadow, a navy eyeshadow, a black eyeshadow base, and a black eyeshadow. Watch this video makeup application tutorial and learn how to do a black and blue Backstreet Boys album cover inspired eye makeup look.
This video shows you how to apply your natural food-based dye, set your dye, and remove your dye. Perfect for an arts and crafts project or a handmade fashion statement!
Watch this cooking tutorial to learn how to make coconut soup which is also know as tom kha gai. For this dish, you can either stir fry your meat or boil the coconut cream first.
Here's a Halo 2 trick for playing multiplayer Capture the Flag. Learn how to get the flag quickly and get blasted out of the base so you get a greater chance of getting it back to your base.
SEO specialist Aaron Wall shares tips on using date based search filters to help you improve your search engine optimization knowledge.
A good stain and varnish can add shine and luster to any piece of wood furniture. Check out these simple steps for staining wood. You will need a painter drop cloth, 2 or 3 1 inch foam brushes, fine grit sandpaper, tack cloth, couple of towels or rags, oil base wood stain and oil base satin varnish.
Watch the lab rats as they breakdown their way of choosing the right mp3 player for you. Maybe its based on flashram or harddrive, the choice is based on your use. These guys explain how they work and what criteria to use to choose the one thats right for you.
After leaning on augmented reality for its outdoor advertising, HBO has called on augmented reality again via Snapchat to promote its Watchmen series.
If you've ever made an Instagram story, you probably know you can add stickers to your stories. These stickers are interactive but, like real stickers, they don't move ... until now. In a Jan. 23 update to the app, more action can be added to your stories with animated GIF stickers.
In case we haven't beaten the '90s revival to death enough, now Nokia is coming back to the US market. The three Android midrange devices that made their debut at Mobile World Congress last month are set for a global release, meaning they will also make their way stateside.
Just over a month ago, the Rubik's Cube world record was smashed by Mats Valk, a Dutch speedcuber, during the Jawa Timur Open 2016. Valk was able to shave 0.16 seconds off the previous record of 4.90 seconds, which was a pretty impressive feat.
Learn how to solve geometry word problems. For example, how would you solve the following problem?
Peeling apples is pure grunt work, especially if you have a recipe that calls for a lot of 'em, like apple pie. You can make this task go by much more quickly if you use something from your tool box—your literal tool box, that is.
While there is definitely no shortage of video game emulators in the Android Market, it lacks in modern gaming consoles. Nintendo 64, Game Boys, and Sega Genesis are all accounted for, but what about emulators for some of the gaming consoles that have come out in the, let's say...past decade?
There's absolutely nothing better than seeing the look of pure and utter shock on someone's face, and that is why I absolutely love this. It is by far one of the best pranks ever, and one of the best videos that I've seen in a while. Seriously. If you've ever used the drive-thru, you've gotta watch this.
Sitting in the Powell Library at UCLA was a constant thing for me. Directly after class, I would streamline my way there to study all night until my eyes shuttered to sleep. For the most part, my classes and professors managed to keep my studying online via PDFs, emails, long essays and journal entries.
In Minecraft, one cool way of getting around those larger fortresses and bases is to set up a minecart. If you're looking for fun or efficient new ways of setting up your minecart station, adding booster carts to make it faster, and adding floor tile switches, check out this video series! There's a plethora of information in here that'll give you the inspiration to have more fun with your base building!
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to you can make a mobile wall of supply depots on your Terran base's...
Unless you're an actual mermaid or a member of the Na'vi, this insane mermaid look probably won't get you any propositions on the street.