Unique Solution Search Results

How To: Make a beautifully unique beaded windchime

Do you have a bunch of flawed beads left over after you make your crafts? You know the ones, the chipped, cracked, sharp ones that don't make the cut and usually get tossed in the garbage? Why not make those into something lovely, where the cracks don't matter? In this two part tutorial, learn how to turn your discarded beads into a beautifully shiny wind chime for your backyard. This chime is unique and makes a lovely noise in the wind. Let's get crafting!

How To: Count unique items in a list in Microsoft Excel

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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.

How To: Highlight rows that contain unique values in MS Excel

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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...

How To: Count unique values greater than a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Prune hybrid-T roses

John White and Rosemary Maddox Master Gardner will teach us how to prune our hybrid t-roses. To begin, you’ll need a set of bypass pruners, long handles loppers for branches or canes, which are bigger than your thumb. You may also need a pruning saw, 10% bleach solution which is 10 parts water + 1 part bleach., an old dog bowl for the bleach, gloves, and a low stool. Begin with the bypass pruners clipping all branches that may be crossing or too close to the main branches that you will keep. ...

How To: Count unique items with multiple criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...

How To: Fix transmission and oil seal leaks fast with AT-205 Re-Seal

If you've got an oil seal leak in a very inconvenient place, then this video by Scotty Kilmer will show you how a little bottle of re-sealer may be able to fix that leak. The vehicle in this video has a leak in the front main seal of the automatic transmission. The seal is pretty cheap, but you have to pull the transmission off to replace it, which can take a serious amount of time. The re-sealer is a better solution, a polymer oil that can mix with all kinds of oils. If you mix AT-205 Re-Sea...

How To: Make a vacation shadow box

In this video, Meg shows us how to make a vacation shadow box. First, clean your seashells with a solution of half water and half beach. Then use any other finds that you want for your vacation shadow box! Take the items, then carefully lay them out where you want them. Use push pins to place them in where you want them. Ad din a box to make it have even more depth. After this, you will be able to place these into the top of the box. From here, you can place this on your wall and enjoy your v...