Understanding the Index and Modulo functions
In this section, we will be looking at the index and modular functions. These tools allow us to remove rows and create additional rows that we can order, which will assist in filtering the relevant data that we need. We will also explore how to rename and delete steps, which will make it easier to understand which step is associated with what it is doing.
Beginning with the modulo function
Before we start looking at the MOD function, it might be beneficial to explain what it is and how it can be used. Modulo is a term used in computing and mathematics that works out the remainder after you have divided a number by a different number. For my example, let's say that we are going to divide 11 by 4. This would give us an answer of 2 with a remainder of 3. This could be very practical in a class situation if you have to divide a class of students into groups of a specific number. Using the formula =mod(A3, B3)
in cell C3, this will...