Excel offers a number of ways to find rows that contain duplicate values. However, most of them focus on finding rows where the value in just one column is repeated. In this lesson, we look at how to use the COUNTIFS function to find rows where values in moree than one column is repeated. We then use the COUNTIFS function in combination with Excel's Conditional Formatting feature to highlight duplicate and even triplicate rows.
Welcome to Fiveminutelessons.com. Get free online courses where you can learn more about Google Analytics, Microsoft Excel, and Microsoft Word, and be more productive in just five minutes.
Search the site for help on a problem you have right now or browse the lessons below to improve your skills. We're adding new lessons all the time, so check back often.
This lesson shows you a way to capture the submission page when someone submits a Drupal 7 webform on your website. This is useful if you have a webform in a block on multiple pages, and you want to know which page someone was on when they submitted the page.
If you work with large Excel spreadsheets, you'll probably know the hassle of scrolling left and right, up and down as you try to work with all that data. You can use the Zoom feature to make the spreadsheet smaller and fit more onto the screen, but that doesn't always give you the result you want. Often, it will make your spreadsheet too small or not small enough.
Bounce Rate refers to the number of visitors who come to your site and then leave again without visiting any other pages on your website.
The SUM function in Excel allows you to add up the values in a range of cells. However, sometimes you only want to add up the cells that meet certain criteria. That's where the SUMIF function comes in handy, along with the more capable SUMIFS function.
Creating a Table of Contents, or TOC, for a document in Microsoft Word 2011 for Mac is not difficult, but it can be tricky to make it look just like you want it. This lesson takes you through the process of creating a dynamic table of contents that can be easily updated to reflect the content in your document.
This lesson shows you how to use Excel to calculate the number of days between two dates. It also shows you how to exclude weekends and holidays from the total.
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here's a quick technique for selecting a range of cells in Excel.
A high bounce rate on a website indicates that your visitors are not engaging once they arrive on your website. That means your website isn't as effective as it could be. Find out here how to reduce your bounce rate.
The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the value of sales of a specific product by a given sales person (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.