Posts tagged "Excel functions", page 7

Excel VLOOKUP tutorial for beginners with formula examples

This VLOOKUP tutorial explains the syntax and provides a number of examples that illustrate the most common usages of the VLOOKUP function in Excel. Continue reading

How to use Excel COUNTIFS and COUNTIF with multiple criteria

The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types – numbers, dates, text, wildcard characters, non-blank cells and more. Continue reading

COUNTIF function in Excel - count if not blank, greater than, duplicate or unique

The article explains Excel COUNTIF function, provides a number of examples and warns about possible quirks when using COUNTIF with multiple criteria and specific types of cells. Continue reading

3 ways to count empty cells in Excel

If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading

How to count non-empty cells in Excel

This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading

Excel conditional formatting formulas based on another cell

This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading

In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading

4 ways for changing case in Excel

In this article I'd like to tell you about different ways to change Excel uppercase to lowercase or proper case. You'll learn how to perform these tasks with the help of Excel lower/upper functions, VBA macros, Microsoft Word, and an easy-to-use add-in by Ablebits. Continue reading

6 Reasons Why Your VLOOKUP is Not Working

The VLOOKUP function is the most popular lookup and reference function in Excel. It is also one of the trickiest and the dreaded #N/A error message can be a common sight. This article will look at the 6 most common reasons why your VLOOKUP is not working. Continue reading

How to convert rows to columns in Excel (transpose data)

In this article, you will find several ways to convert rows to columns and columns to rows in Excel. These solutions work in all versions of Excel 365 - 2007, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading

How to sum and count cells by color in Excel

Even though Microsoft Excel has a variety of functions for different purposes, none can count or sum by color of a cell. Aside from third-party tools, there is only one possible solution - create your own functions. Continue reading

How to quickly extract domain names from URLs in Excel

A few tips and pieces of advice will help you get domain names from a list of URLs using Excel formulas. Two variations of the formula let you extract the domain names with and without www. regardless of the URL protocol (http, https, ftp etc. are supported). The solution works in all modern versions of Excel, from 2007 through 2016. Continue reading

How to compare two columns in Excel and delete duplicates (highlight, color, move)

It will take you about 10 minutes to read this article and in the next 5 minutes (or even faster if you choose the 2nd solution described in the article :) you will easily compare two Excel columns for duplicates and remove or highlight the found dupes. Okay, the countdown is started! Continue reading