Apr 24, 2014
This is the last part of a 4-part series about counting in Excel. In the previous tutorial, I explained how to count the number of rows in a Table that match a given criteria. However, I did it by adding an extra column into the Table. In this tutorial I show an...
Apr 14, 2014
This is the third part of a 4-part series about counting in Excel. This short tutorial demonstrates how to count the number of rows in a table that match a given criteria. The screenshot above is taken from an Excel file that contains a list of tutorials on this...
Mar 29, 2014
This is the second part of a 4-part series about counting in Excel. This short tutorial demonstrates how to automate counting the number of rows in a Table.
Mar 24, 2014
Using the COUNT and COUNTA functions, this short tutorial demonstrates how to count the number of items in a list in Excel
Mar 16, 2014
This week I received an email from someone who had 258 cells containing strings that they wanted to combine into a single cell. Rather than using VBA, I worked out another way to do it. This video shows you how. Note that the CONCATENATE function has a limit of 255...
