When you get raw Excel data, you sometimes find that text, numbers and non-alphanumeric characters are all mixed up together, and you need to remove the non-alphanumeric characters before you can work with the data. One way of removing non-alphanumeric characters would be to go through the dataset cell by cell and delete them, but … Read more

There are situations in Excel where you may want to count values in one column according to criteria in one or more other columns. For example, you may want to know from your dataset how many manufacturers of different products are based in certain regions of the country. Here are some of the ways you … Read more

The COUNTIF function counts the number of cells in a given data range that meet specific criteria or conditions. The COUNTIF function can also return the number of cells containing text values that partially match the criterion value. We’ll use the following dataset to demonstrate how the COUNTIF function can be used to count cells … Read more