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...

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...

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.

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...