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.
Salt dough can be used like clay for craft. This video demonstrates how to make salt dough. The ingredients required to make salt dough are a cup of salt, two cups of flour, a cup of water and food coloring. Make sure to cover your working surface with old newspaper and use a painting apron as this can get messy. Add the salt and flour in a bowl and mix with a spoon. Then measure one cup of water and add quite a good amount of food color to get the desired color and mix it into the salt-flour...
If you would like to create the look of stitches or sutures on your clay sculptures, you will need the following: clay, a toothpick or sharp implement, and a cutting tool.
In this Fine Art video tutorial you will learn how to understand your lens and its effect on depth of field. The lens in the video has some inscriptions which are interpreted like this. 50mm is the focal length of the lens. The aperture is from f1.4, which is the widest lens opening to f16, which is the smallest lens opening. The higher the number the lesser the lens opening. Aperture determines the amount light that comes through the lens. Aperture also decides the depth of field. With a wid...
In this video, we learn how to make french toast with panettone bread. First, mix 2 eggs with a small amount of milk and orange juice. Add vanilla, brown sugar and cinnamon to the bowl and mix together. Now grab your panettone bread and cut it into thick slices. Dip the bread into the mixture and coat it on both sides letting it soak up for a little bit. Once finished, place bread into a hot skillet for 1 minute on each side, then place in a toaster oven for 2 minutes. Once finished, it's goi...
The first problem that is show is exponential decay. First you will need to create a table with hours and substance left. The next step is to find the trend by noting that we are left with a certain percentage of the substance. One you have the trend you will use this to calculate the amount of substance left in said hours, in this case 6 hours. The following example shows you how to solve exponential growth. It is essentially the same except for the fact that you will be increasing, so inste...
Grapes, raisins and pomolo are placed in jars and spring water is added to them. The jars are tightly covered and left for 5 days to a week; until fermented. The jars are shaken once daily and the lid is opened to allow air to get in. After maturity, where they made fizzing sounds and they started to swell to the top . They are strained and the liquid is put to back into the jars, closed and left for a week. An amount of the liquid is poured out of the jars and flour is placed in each and sti...
In this video tutorial, viewers learn how to speed up a Windows PC using a USB flash drive. Begin by clicking on the Start menu and select My Computer. Now right-click on the flash drive and select Properties. Click on the Ready Boost tab and check Use this device. Select the amount of space and click Apply. Then click OK. To remove the flash drive, right-click on the flash drive and click on Properties. Click on the Ready Boost tab and check Do not use this device. This video will benefit th...
In this video, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...
In this how-to video, you will learn how to check your personal computer's RAM, processor speed, and operating system information on Windows XP. First, go to start and select my computer. From here, click view system information to open a new window. A screen will show you the information you need, such as the type of operating system you are running, the size and speed of the processor, and the amount of ram you have. Click okay to exit this window. This will be helpful for doing upgrades or...
How much air is actually inside a packing peanut? There is a simple experiment to conduct to see what is leftover. To begin, pour 200 ml of acetone into a glass container and add approximately 1800 ml of packing peanuts. Stir with a wooden spoon to dissolve. The video's author starts with the 1800 ml and realizes that that isn't enough. He then keeps adding until he has added an entire large bucket to the original 200 ml of acetone. After all are dissolved, all that is left in the glass conta...
In this video tutorial, viewers learn how to use the blend tool in Adobe Illustrator. The blend tool will allow users to create objects between two strokes or filled objects. When you double-click on the blend tool, there will be 3 options to select from. Select the spacing and press OK. The three spacing options are: Smooth Color, Specify Steps and Specified Distance. Users are also able to select the amount strokes between the two objects. Now select the points of the two objects and it wil...
To make a pina colada, start by adding 40 milliliters of Bacardi white rum into the glass portion of a Boston shaker. To that, add 50 milliliters of Koko Kanu (coconut liqueur). Then add cream of coconut, heavy cream, lime juice and pineapple juice. Add ice to the glass. If wanted, add a small amount of sugarcane syrup. Cover the glass with the stainless steel portion of the Boston shaker and shake to mix and cool the drink. To serve put ice in a hurricane glass, and strain the drink into the...
This is your basis step by step on how to do graffiti on walls - in your house for decoration, of course, not on the streets for vandalism! The best spray paint is made with krypotnite added into the paint. While you will want to paint directly on the surface, you don't want to be exposed to excessive winds or temperature when doing your graffiti, so you may be somewhat at the mercy of mother nature. Start by sketching your design with pencil, making sure that it takes the maximum amount of s...
In this video, we learn how to do basic text effects in Adobe Illustrator. First, open up Adobe Illustrator and make a new document. Now, type in your desired text and change your font to one that you prefer. To make your text turn into a radiant, you will click "file" then "type" then "create outline". Now you will click on your text then click your radiant swatch. Then, go to "gradient" and adjust your colors to which you prefer. You can now put a stroke on it using the "stroke" tool and ch...
In order to mud and tape the corners with new drywall you, you will need spackle, a sturdy ladder, and a putty knife. Scoop out a dollop of spackle (i.e. mud) with your putty knife. Place your putty knife where the ceiling and the wall meat. Spread the putty evenly, as you extend your arm left to right or right to left. Make sure that you apply putty all the way up to the corner.
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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
Bhavna shows us how to store ginger, garlic and green chili paste. The demonstration is done with ginger. Cut the ginger into small pieces. Skin can be left on or if you prefer you can remove the skin. Put the pieces of ginger into the food processor and blend. After the ginger has blended, remove and put into a bowl. Add lots of salt for freezing. Fold the salt into the ginger. Place into plastic containers for freezing. The same process is done for garlic and green chilies. When you are rea...
Depending on what state you are in will have different laws on the amount of tint that is legal to have on your car window. If your tint is too dark for the state you are in there is a way that is not too difficult for you to remove the tint yourself. You will have to heat up the car but having it in the sun and running it with the heat and defrost on until the window is hot. Then you will simply have to catch the edge of the tint with a new razor blade and start to peal. It should come off i...
In this how-to video, you will learn how to play the song "Ain't Got You" by Alicia Keys on the ukulele. You will need basic knowledge of chords and a tuned ukulele. First, play the chords C7, Bm, Am, and G7. Play this twice before playing G7, Bm, Em, Am, D. Repeat this for the verses of the song. Next, play G7, Am, Bm, and Am. Repeat this for the chorus. The next part involves you playing the chords G7, Am, Bm, C7, Bm, Am, G7, Am, and G7. Repeat this before moving back to the verse chord pro...
In this video, we learn how to cut a line using paint onto your walls. To do this you will need walls, a paint brush and your choice of paint. Make sure you get just the right amount of paint onto your brush and place the bristles against the wall right next to the corner of the wall. Slide it down making the line as straight as possible. Keep going until you have a line all the way down the corner, making it very straight and neat. Do this on both of the walls and you will a have professiona...
This video shows the viewer how to caulk a bathroom floor – this is where some type of sealant is used to fill the joint between the surface of the floor and the side of the bath. The first stage is to select a suitable sealant, the video recommends a sealant that can be painted as it is useful if you every need to redecorate. Squeeze a liberal amount of sealant into the crack. Then using a dampened finger press the sealant into the corner whilst simultaneously scraping the excess away. Final...
Alwaysnforever559 teaches viewers how they can make their own color acrylic for nails! First, you will need a container, a clear powder (Acrylic) and an eyeshadow color that you will like for your nails. Pour in the acrylic clear powder in the container and pour the same amount of your simmer or eyeshadow color into the container. Close this container and shake the ingredients to mix them up. Now, your powder should be a mix of the white and the eyeshadow color you put in. First, get your bru...
This is a great instructional video on how to measure a quilt for binding. This video teaches you about binding. First you have to get your quilt and tape measure. You need to know the size of your quilt. You have to be careful while measuring a quilt. You can measure the breadth with your measuring tape first. Then you can measure the breath as well accurately. You can take measurements down the center of the quilt. In some cases you can measure from one side, the center and the other side. ...
Photography is a fast growing hobby with the relative drop in prices of high grade equipment. The use of different filters in photography is a very common thing, and different filters have very different uses. The neutral density (ND) filter reduces the amount of light reaching the film or sensor. This allows the photographer to create different effects with the available light, allowing slower shutter speeds and larger apertures. The video helps explain the differences in shutter speeds and ...
In this video, we learn how to make eggs over easy. You will need butter, a small cooking pan, eggs, a spatula and a little bit of water. First, put your pan on medium heat and put a tbsp in the pan while it's heating. Once the butter is melted, pick up the pan and swirl the butter around until it's gotten to all parts of the pan. Next, crack your eggs and let them fall out into the pan (without cracking the yolk). Now, pour a small amount of water around the edges of your eggs. After this, g...
This video shows you how to calculate the percentage yield in chemistry. To find the percentage yield, you will need to divide the actual yield by the theoretical yield. Then, multiply it by 100: i.e. % yield = actual yield/theoretical yield x 100. An actual yield is the amount of a substance produced in an actual laboratory experiment. It is based on an actual physical measurement of a quantity. The theoretical yield is the yield as is calculated on paper: i.e. through calculations. Therefor...
In this how-to video, you will learn how to make a repair in cut leather. This is useful if you have damaged leather you would like to repair yourself. Make a knife cut in the leather, and then cut and place a sew patch into the leather. Push it underneath the leather. Now, glue the sew patch in place with inexpensive craft glue. Rub it around the leather and edges of the cut. Wipe off excess glue with a damp cloth and wait until it dries. Place something heavy on it for a good amount of time...
Ingelton Pottery demonstrates how to throw a chip and dip pottery plate. First, well a ball of clay and put it on a pottery wheel. Use your hands and ample amounts of water to depress the sides of the clay forming an indented rim with a raised center. Use your thumb to define the center hub. Create a thin side to the plate. Wet your hands and press down on the center hub, creating a depression. The plate should now have a two bowls with one sitting inside of the other one. Use a blade to scra...
In this video tutorial, viewers learn hoe to apply Frontline for dogs. Be sure that you get the appropriate amount of dosage for your dog. Frontline is a topical flea intake preventive for dogs. Do not let your dog go into water 72 hours before and 72 hours after apply the product. Begin by apply the product in between the shoulder blades. Do this by parting the fur and apply the product onto the skin. Also apply the product at the base of the tail. This process needs to be done once a month....
To make the perfect omelet, take the ingredients such as the eggs, onions, tomatoes, cheese and ham ready. Spray the pan with butter and use four eggs for a better presentation. Beat the eggs on a bowl and mix in a little amount of fresh milk. Place it on the pan and let it cook for a little while. Wait for the bottom to solidify before placing the rest of the ingredients inside the pan. Place the rest of the ingredients and then keep it boiling. Heat up the oven and place the pan inside for ...
Macherie has an excellent method for conditioning hair. No matter what texture, deep conditioning is essential for healthy hair. Shampoo with hydrating/detangling shampoo. When drying focus on removing the excess moisture from your hair. Conditioner works best and penetrates hair that's not sopping wet. Using her fingers, she separates her hair, as she doesn't use a comb when its in this fragile state. Use approximately a quarter size amount of conditioner starting from the roots to the end. ...
The narrator describes how to paint your nails with gold leopard print. Using two coats you can now have gorgeous, glossy nails within a short amount of time. First by making an x shape (like a French tip) then with a second coat going over with gold. Finally by "striping" and "spotting" your nails (like a leopards skin) it finishes off the look. This is a simple process that anyone can follow through with. The end results are fantastic nails resembling leopard pattern. What you need: Gold Sh...
In this how-to video, you will learn how to make a .gif animation from video footage. First, open Photoshop, click file and select import video frames to layers. Next, select the video you want to use and open it. Once this is done, you will see the amount of frames in the videos as layers in the video. Go to window and animation to open a new display for the animation. If you want to shrink the .gif image size, go to edit and image. Change the size to your liking. Now, just go to file and se...
Here's how to enter recovery mode on your iPhone or iPod touch the easy way. No need to press the sleep button and the home button at the same time for x amount of seconds, just turn your device off, if the device is frozen and can't be turned off normally just hold the above buttons until it turns off, now press and hold the home button and plug the device in. Do not let go of the home button until you see a screen in which the connector cable is displayed and there is an arrow pointing from...
In this video tutorial, viewers learn how to make traditional horchata. Begin by filling the blender with water and add in some cinnamon sticks. Then add in a cup of dried rice and turn on the blender to mix it. Now pour the mixture out into a strainer with a pitcher or cup underneath. The strainer will catch all the leftover rice gains. Then add in 1 tsp of vanilla, small amount of almond extract and 1/2 cup of sugar. This recipe is very fast, simple and easy to do. This video will benefit t...
In this video tutorial, viewers learn how to secure a Mac Book Pro. Begin by opening the System Preferences and select Security under Personal. In the General tab, users are able to put on a password when the computer goes to sleep or screen-saver, disable automatic log in and log out after a certain amount of minutes. To set a password, go back to System Preferences and select Accounts under System. Then click on Change Password and input your password. This video will benefit those viewers ...
A reoccurring problem that many iPod Touch/iPhone users are encountering is their device entering a permanent "recovery mode" state by using firmware. SamlvnErin has an immediate, and effective solution which can fix your problem with little hassle and the procedure is absolutely free. SamlynErin starts off by showing us an iPod in "recovery mode". He then logs into Mega Upload and downloads Quickpwn2.2 by filling a little code fill at the top right hand corner. It then will give you the opti...
This video shows how to make Sopa de Fideo, a traditional Mexican soup. In the blender put some Roma tomatoes, two cloves of peeled garlic, a small amount of onion, and two tomato and chicken bouillon cubes, and blend together.
Being in the wilderness for an extended amount of time can be bad for your health. One thing it can do for you is cause major problems in the personal hygiene department. Find out how to keep yourself nice and clean by using a yucca plant.