Up your game with a Wildcard!

Functions 10: Wildcard Time to learn: 10 minutes Ever wanted to find out something about your products just from their names?  Tired of counting stuff BY HAND?  God forbid. Ready to save yourself hundreds of hours doing manual work that can be better spent conceptualising and innovating? Let’s get it on! Let’s start with some data.  This is a list of 5 items in a gun catalogue. We want to find out how many guns are “Automatic”, how many are “Rifles” and how many of them can be characterised under the “Machine” category. Step 1: Let’s create a title for ‘Names Beginning with “Automatic”. Step 2: Now, by using a COUNTIF and a wildcard “*”, we will find out how many names begin with “Automatic”, with the following function: =COUNTIF(A2:A6,”automatic*”) Neat?  That’s right. Step 3: Now, by using the COUNTIF and a wildcard “*”, we will find out the number of names that end with “Rifle”, with the following function:

read more Up your game with a Wildcard!