Archive for COUNTA function
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 […]
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 […]
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 […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
