Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 57 of 60 · 540 articles
How to calculate running count
This article show how to calculate running count by using the COUNTIF and COUNTIFS functions. The running totals help you to track number of value occurrences in your data.
How to get nth match with VLOOKUP
This how-to article shows you how to get nth match with VLOOKUP. Unfortunately; Excel doesn't have a built-in function to find any value beyond first match. If your data is sorted, locating position with the MATCH function and increasing one-by-one.
How to Excel SUM Formula Filtered Values in Datatables
Excel SUM formula includes all values in a range. Using he SUBTOTAL function is the easiest way to overcome limitations and filtered values.
How to Count the Number of Columns in Excel
In this article we're going to show you how to count the number of columns using the COLUMNS function in Excel.
How to Get The Number of Rows Containing Data in Your Table
Counting the number of rows in Excel can be repetitive when done manually. However, you can use a simple formula to automate this task.
How to create dependent dropdowns
Learn how to create dependent dropdowns. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to remove blanks from a list
Most of times raw data is not organized and may include empty cells. How to remove blanks from a list article will show you to eliminate those cells and create a new list without them by Excel formulas.
How to convert a number to time units
Learn how to convert a number to time units. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to highlight a column
Learn how to highlight a column. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.