How to use the COUNTA function

The COUNTA function counts the non-empty or blank cells in a cell reference. The picture above demonstrates the COUNTA function […]

COUNTIF not blank cells

The COUNTIF function is very capable of counting non-empty values. Column B above have a few blank cells, they are […]

Lookup with an unknown number of criteria

Rashid asks: I used your array formula with great success to find the search results from multiple critera. However my […]

Add or remove a value in a drop down list

Cell B3 contains a drop down list (Data Validation). The values in drop down list are from column H. I […]

Use dynamic ranges to automatically add new values

This post demonstrates how to automatically add new values to a drop down list and a chart. This tutorial contains […]

Create a dynamic named range

A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]

How to create a dynamic pivot table and refresh automatically

David Hager commented: Looks like an easy pivot table solution to me. Thanks for your comment! Now i know how to […]

Create a drop down list containing alphabetically sorted values

Overview This article describes how to create a drop down list populated with sorted values from A to Z. The […]

Create dependent drop down lists containing unique distinct values

This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]

How to create a dynamic chart

Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]